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.Describe the relationship between OrderHeader and Customer.

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.