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. The complet design should
include two additional related tables. Describe them.