## Airlines

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

## Fleets

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

## Airlines_Fleets

airlineId | fleetId
--- | ---
(→ Airlines.id) | (→ Fleets.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 5