## 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