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 |