Design a normalized order management database with the requirements provided in theMS 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.

CB 125% A Add Category Comment Collaborate View Zoom Insert Table Chart Text Shape Media C Format Organize Cell + Sheet1 Sheet2 Sheet3 Table Text Arrange Lill to - d do- O B C D E buyer phone buyer email credit rating 12 Customer Shipping location number receiver name Table Styles . receiver phone receiver email Table Options ship-to address Title Caption 19 Order Header 20 order number N order date Headers & Footer 22 shipment method 23 24 Order Detail 25 item number Rows 13 V 26 part number Columns 5 27 unit price 28 total quantity Table Font Size A A 29 30 Delivery Schedule 31 delivery number Table Outline 32 location number O 1 pt 33 quantity Outline Table Title 34 due date 35 36 Part Gridlines 37 part number 38 standard price 39 40 Customer-Part Relationship Alternating Row Color O 41 customer number 42 part number Row & Column Size 43 special price Height 17 pt Fit Width 164 pt Fit Text special price125% A View Zoom Add Category Insert Table C Chart Text Shape Media Comment Collaborate Format Organize + Sheet Sheet1 Sheet2 Sheet3 Sheet Name ORDER MANAGEMENT Sheet1 Entity-Relationship ITEM Customer Header Background customer number buyer nam bill-to address Duplicate Sheet buyer phone buyer email Delete Sheet 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