previous | start | next

Answers

  1. The telephone number for each customer is unique–a necessary requirement for the primary key. However, if a customer moves and the telephone number changes, both the primary and all foreign keys would need to be updated. Therefore, a customer ID is a better choice.
  2. Customer 3176 ordered ten toasters.


previous | start | next