Tables Containing Information from Other Tables
A sales order table should have:
- a unique key (order number),
- the date of the order,
- information about the customer making the order, and
- information about the salesperson taking the order.
Q: Why not include order item information in this table?
A: There may be multiple items in the order, which the table
definition cannot predict.