Order Management – Design a normalized order management

Order Management

 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

Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.