Each customer is uniquely identified by a CustomerID. Each order is uniquely ide

Question

Each customer is uniquely identified by a CustomerID. Each order is uniquely identified by an OrderNumber. Each order is made up of an OrderHeader and one or more OrderDetails. A customer can have zero or more orders on file at any time.

Customer

PK

CustomerID

CustomerName

ContactName

CustomerAddress

PrimaryPhone

OrderHeader

PK

OrderNumber

OrderDate

EmployeeID

OrderDetails

OrderNumber

DetailItemNumber

ItemPartNumber

ItemCost

ItemQuantity

1. What should you choose as the foreign key in OrderDetails? To what should it relate?

Customer

PK

CustomerID

CustomerName

ContactName

CustomerAddress

PrimaryPhone

Explanation / Answer

Item, Employee are the two other tables

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

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