## Airports

id | name | city | country
--- | --- | --- | ---
1 | Los Angeles International Airport | Los Angeles | USA
2 | Dubai International Airport | Dubai | UAE
3 | London Heathrow Airport | London | UK
4 | Tokyo Haneda Airport | Tokyo | Japan
5 | Sydney Kingsford Smith Airport | Sydney | Australia

## Airlines

id | name | alliance | independent_carrier
--- | --- | --- | ---
1 | American Airlines | OneWorld | 0
2 | Emirates | None | 1
3 | British Airways | OneWorld | 0
4 | ANA | None | 0
5 | Qantas | OneWorld | 0

## Aircrafts

id | model | max_capacity
--- | --- | ---
1 | Airbus A320 | 180
2 | Boeing 747 | 400
3 | Airbus A380 | 850
4 | Boeing 777 | 360
5 | Embraer E190 | 100

## Alliance_Aircraft

airline_alliance | aircraft
--- | ---
(→ Airlines.name) | (→ Aircrafts.model)
American Airlines | Airbus A320
British Airways | Boeing 747

## Independent_Aircraft

independent_carrier | aircraft
--- | ---
(→ Airlines.name) | (→ Aircrafts.model)
Emirates | Airbus A320
Qantas | Boeing 777

## Flights

flight_id | departure_airport | arrival_airport | airline_id | aircraft_id
--- | --- | --- | --- | ---
| (→ Airports.id) | (→ Airports.id) | (→ Airlines.id) | (→ Aircrafts.id)
1 | 1 | 2 | 1 | 1
2 | 2 | 1 | 2 | 2
3 | 3 | 4 | 3 | 3
4 | 4 | 3 | 4 | 4
5 | 5 | 1 | 5 | 5