There are five tables in the Cars database:
They are diagrammed below.
| id | owner | car |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 3 | 2 |
| id | name |
|---|---|
| 1 | Doe, Janet |
| 2 | Doe, John |
| 3 | Smith, Jim |
| id | vin | model |
|---|---|---|
| 1 | 0123456789abcdefg | 1 |
| 2 | abcdefg0123456789 | 3 |
| id | name | manufacturer |
|---|---|---|
| 1 | Camry | 3 |
| 2 | Fusion | 1 |
| 3 | Buick Regal | 2 |
| id | name |
|---|---|
| 1 | Ford |
| 2 | General Motors |
| 3 | Toyota |
| Owner | Make | Model | VIN |
|---|---|---|---|
| Doe, Janet | Toyota | Camry | 0123456789abcdefg |
| Doe, John | Toyota | Camry | 0123456789abcdefg |
| Smith, Jim | General Motors | Buick Regal | abcdefg0123456789 |