Design a normalized order management database with the requirements provided in the MS Excel worksheet. Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram using the MS Excel worksheet to illustrate the relationships between entities and attributes. ORDER MANAGEMENT Entity-Relationship ITEM: Customer Header · customer number · buyer name · bill-to address · buyer phone · buyer email · credit rating Customer Shipping · location number · receiver name · receiver phone · receiver email · ship-to address Order Header · order number · order date · shipment method Order Detail · item number · part number · unit price · total quantity Delivery Schedule · delivery number · location number · quantity · due date Part · part number · standard price Customer-Part Relationship · customer number

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 5P

See similar textbooks

Related questions

Question

Design a normalized order management database with the requirements provided in the MS Excel worksheet. Each record should have at least one primary key field specified. After identifying the records and their corresponding fields, draw an entity-relationship (ER) diagram using the MS Excel worksheet to illustrate the relationships between entities and attributes.

		ORDER MANAGEMENT
		Entity-Relationship
ITEM:
Customer Header
· customer number
· buyer name
· bill-to address
· buyer phone
· buyer email
· credit rating

Customer Shipping
· location number
· receiver name
· receiver phone
· receiver email
· ship-to address

Order Header
· order number
· order date
· shipment method

Order Detail
· item number
· part number
· unit price
· total quantity

Delivery Schedule
· delivery number
· location number
· quantity
· due date

Part
· part number
· standard price

Customer-Part Relationship
· customer number
· part number
· special price

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions