Linking Tables

• In the table above, customer data are not replicated
• Customer table contains a single record for each customer
• Invoice table has no customer data
• The two tables are linked by the Customer_Number field
• The customer number is a unique identifier
  • We introduced the customer number because the customer name by itself may not be unique