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