| id | name | country | city |
|---|---|---|---|
| 1 | Heathrow | UK | London |
| 2 | Schiphol | Netherlands | Amsterdam |
| id | name | headquartered_at |
|---|---|---|
| (→ Airports.id) | ||
| 1 | BA | 1 |
| 2 | KLM | 2 |
| id | model | max_passengers | max_range | airline_id |
|---|---|---|---|---|
| (→ Airlines.id) | ||||
| 1 | Boeing 787 Dreamliner | 300 | 7639 | 1 |
| 2 | Airbus A380 | 525 | 8000 | 2 |
| 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 |
| 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 |