How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Mr. Gregory White Your Own Question
Mr. Gregory White
Mr. Gregory White, Professor
Category: Homework
Satisfied Customers: 5240
Experience:  M.A., M.S. Education / Educational Administration
46856550
Type Your Homework Question Here...
Mr. Gregory White is online now
A new question is answered every 9 seconds

Design a normalized order management database with the requirements

Customer Question

Design a normalized order management database with the requirements provided in the MS Excel worksheet. I have to put it in Excel
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
Submitted: 1 year ago.
Category: Homework
Customer: replied 1 year ago.
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.
Expert:  Mr. Gregory White replied 1 year ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.

Related Homework Questions