The part number must be unique
within the order, but NOT
across orders.
The customerID uniquely identifies
each customer.
The customerID uniquely identifies
each customer.
The customerID uniquely identifies
each customer.
Each order must refer to a known customer.
The part number uniquely identifies
each orderable item.
Each order must refer to a known part number.
Identify ordered customers and
shipping quantities. Note that
while schema already enforces
the following constraint, the
'key' also assures that there *is*
a customerID and a shippingQuantity
identified for each order
Ensure a shipped customer/qty
for each ordered customer/qty