id | Name | Location | YearEstablished |
---|---|---|---|
1 | JFK International | New York City | 1948 |
2 | Dubai International | Dubai | 1960 |
3 | Heathrow Airport | London | 1946 |
4 | Charles de Gaulle Airport | Paris | 1974 |
5 | Hong Kong International Airport | Hong Kong | 1998 |
id | AirportID | Airport_Expansion | Increased_Capacity |
---|---|---|---|
(→ Airports.id) | |||
1 | 1 | Terminal 8 construction | 2000 Passengers per day |
2 | 2 | Concourse D expansion | 3000 Passengers per day |
3 | 3 | Northwest Terminal extension | 1500 Passengers per day |
4 | 4 | Runway extension project | 2500 Passengers per day |
id | AirportID | Renovation | Increased_Capacity |
---|---|---|---|
(→ Airports.id) | |||
1 | 1 | Energy efficient lighting system | 1000 Passengers per day |
2 | 2 | Baggage handling system upgrade | 1000 Passengers per day |
3 | 3 | Security checkpoint modernization | 500 Passengers per day |
4 | 4 | Passenger lounges renovation | 1500 Passengers per day |
id | FlightNumber | DepartureTime | ArrivalTime | AirportID |
---|---|---|---|---|
(→ Airports.id) | ||||
1 | AA123 | 06:00:00 | 08:00:00 | 1 |
2 | BA456 | 08:00:00 | 10:00:00 | 2 |
3 | QF789 | 10:00:00 | 12:00:00 | 3 |
4 | CX123 | 12:00:00 | 14:00:00 | 4 |
5 | LH456 | 14:00:00 | 16:00:00 | 1 |
6 | MU789 | 16:00:00 | 18:00:00 | 2 |
7 | AE998 | 18:00:00 | 20:00:00 | 3 |
8 | ET123 | 20:00:00 | 22:00:00 | 4 |
id | AirlineName | HeadquartersLocation | FleetSize | AirportID |
---|---|---|---|---|
(→ Airports.id) | ||||
1 | American Airlines | Fort Worth, Texas | 950 | 1 |
2 | British Airways | Watford, Hertfordshire | 280 | 2 |
3 | Qantas Airways | Mascot, New South Wales | 180 | 3 |
4 | Cathay Pacific | Hong Kong | 140 | 4 |
5 | Lufthansa | Cologne | 300 | 1 |
6 | Emirates | Garhoud, Dubai | 250 | 2 |
7 | Aeromexico | Miguel Hidalgo | 130 | 3 |
8 | Ethiopian Airlines | Addis Ababa | 110 | 4 |