Design a normalized order management database with the requirements provided in

Question

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.

TEM 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 o shipment method Order Detail item number part number unit price total quantity Delivery Schedule delivery number location number quantity o due date Part part number standard price ORDER MANAGEMENT Entity-Relationship

Explanation / Answer

Okay - here are the tables followed by 2 Diagrams - tblNames are in Bold - the fields are listed below them with the primary key Bolded and the foreign keys are Bold and Italicized. The first diagram is an actual ERD Entity relationship diagram - but I included another relationship diagram showing the types of relationships eah entity has.

Tables

tblProducts

(ProductID, Description, QyOnHand, CatID, Markup, UnitPrice)

tblCategories

(CatID, Category)

tblCustomers

(CustID, CustName, Address1, Address2, City, State, Zip, phone, email, Terms)

tblOrder

(OrderID, CustID, OrdDate, ShipDate)

tblOrdDetail

(OrdDetailID, OrdID, ProductID, Qty, UnitPrice, ExtPrice)

tblVendor

(VendorID, VendName, VendAddress, City, State, Phone, Fax, Contact)

tblVendorTrx

(VendTrxID, TrxDate, VendID, ProductID, Qty, Price, ExtPrice)

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.