## Airports

id | name | country | city
--- | --- | --- | ---
1 | Heathrow | UK | London
2 | Schiphol | Netherlands | Amsterdam

## Airlines

id | name | headquartered_at
--- | --- | ---
|  | (→ Airports.id)
1 | BA | 1
2 | KLM | 2

## Aircrafts

id | model | max_passengers | max_range | airline_id
--- | --- | --- | --- | ---
|  |  |  | (→ Airlines.id)
1 | Boeing 787 Dreamliner | 300 | 7639 | 1
2 | Airbus A380 | 525 | 8000 | 2

## OnboardServices

id | service_name | description | aircraft_id
--- | --- | --- | ---
|  |  | (→ Aircrafts.id)
1 | Meal Service | A variety of meals served on board. | 1
2 | Snack Service | Light snacks available for purchase. | 2

## InflightEntertainments

id | entertainment_name | description | aircraft_id
--- | --- | --- | ---
|  |  | (→ Aircrafts.id)
1 | Movie Selection | Wide range of movies available for viewing. | 1
2 | Games Library | Variety of games available for play. | 2