## 28.1.3 Implementing One-to-Many Relationships (cont.)

Break into 2 tables Link items to an invoice w/`Invoice_Number` |
Item
Invoice_ Number | Product_ Code | Quantity
--- | --- | ---
`INTEGER` | `CHAR(10)` | `INTEGER`
11731 | 116-064 | 3
11731 | 257-535 | 1
11731 | 643-119 | 2
11732 | 116-064 | 10
11733 | 116-064 | 2
11733 | 643-119 | 1
Invoice
Invoice_ Number | Customer_ Number | Payment
--- | --- | ---
`INTEGER` | `INTEGER` | `DECIMAL(10,2)`
11731 | 3175 | 0
11732 | 3176 | 249.5
11733 | 3175 | 0

prev |top |next