| id | name | country |
|---|---|---|
| 1 | Air France | France |
| 2 | KLM Royal Dutch Airlines | Netherlands |
| 3 | Delta Air Lines | United States |
| 4 | Emirates | UAE |
| 5 | Lufthansa | Germany |
| id | fleetName | capacity |
|---|---|---|
| 1 | Boeing_737 | 200 |
| 2 | Airbus A380 | 517 |
| 3 | Bombardier CRJ-900 | 76 |
| 4 | Embraer E190 | 100 |
| 5 | De Havilland Canada Dash 8 Q400 | 78 |
| airlineId | fleetId |
|---|---|
| (→ Airlines.id) | (→ Fleets.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 5 |