Question: Can someone please help me understand what this is asking with the Excel Worksheet provided? Design a normalized order management database with the requirements provided

Can someone please help me understand what this is asking with the Excel Worksheet provided?

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.

Can someone please help me understand what this

AWNE 1 2 3 4 ORDER MANAGEMENT Entity-Relationship ITEM: Customer Header 5 customer number 6 buyer name 7 bill-to address 8 9 buyer phone buyer email credit rating 10 11 12 Customer Shipping location number 13 . 14 receiver name 15 receiver phone 16 receiver email . 17 ship-to address 18 19 Order Header 20 order number 21 order date 22 shipment method 23 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

Can I get some assistance in how to 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...

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...

Can someone please help me make this run? I don't understand why it is not //AssignReadString public class AssignReadString { } import java.awt.image.BufferedImageFilter; import...

By using Finite Differences Method, determine the deflection at midspan, use h = L/4 , El = constant 18 kips/ft -8 ft- L=16 ft

Consider an ideal Rankine cycle using water with a high-pressure side of the cycle at a supercritical pressure. Such a cycle has a potential advantage of minimizing local temperature differences...

Which type of municipal bond requires analysis similar to that used for corporate bonds? Check all that apply: General obligation bonds Revenue bonds Insured bonds Appropriation - backed bonds

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...