28.1.2 Linking Tables (cont.)

  • In C++, many objects can refer to a single object
  • To accomplish this in SQL:
    • Break data into 2 tables
    • Solves replication problem
    • Cust# primary key for Customer table
      • A foreign key in the Invoice table
      • Links tables
Invoice
Invoice_
Number		 Customer_
Number		 Customer_
Payment
INTEGER INTEGER DECIMAL(10,2)
11731 3175 0
11732 3176 249.95
11733 3175 0
prev |top |next