Normalized Order Management Database

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.

 

See attachment

 

Assignment 2 Grading Criteria     

Maximum Points

Logically selected entities, attributes, and all unique identifiers.       
60

Logically identified relationships between entities.       40

Logically laid out individual database records.             

50

Logically identified primary key fields for each table.    30

Labeled the general layout.           20

Total   200

Need this to be in APA format with in-text citations and no wiki websites, please.

Sheet1

·        location number

·        part number

·        customer number
·        part number

				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
·        quantity
·        due date
Part
·        standard price
Customer-Part Relationship
·        special price

Sheet2

Sheet3