## 28.1.2 Linking Tables (cont.)

- Store customer info in invoice table?

Invoice_Number | Customer_ Name | Customer_ Address | Customer_ City | Customer_ State | Customer_ Zip | ...
--- | --- | --- | --- | --- | --- | ---
`INTEGER` | `CHAR(40)` | `CHAR(40)` | `CHAR(30)` | `CHAR(2)` | `CHAR(10)` | `...`
11731 | Sam's Small Appliances | 100 Main St. | Anytown | CA | 98765 | ...
11732 | Electronics Unlimited | 1175 Liberty Ave. | Pleasantville | MI | 45066 | ...
11733 | Sam's Small Appliances | 100 Main St. | Anytown | CA | 98765 | ...

prev |top |next