Airports

idNameLocationYearEstablished
1JFK InternationalNew York City1948
2Dubai InternationalDubai1960
3Heathrow AirportLondon1946
4Charles de Gaulle AirportParis1974
5Hong Kong International AirportHong Kong1998

Expansions

idAirportIDAirport_ExpansionIncreased_Capacity
(→ Airports.id)
11Terminal 8 construction2000 Passengers per day
22Concourse D expansion3000 Passengers per day
33Northwest Terminal extension1500 Passengers per day
44Runway extension project2500 Passengers per day

Renovations

idAirportIDRenovationIncreased_Capacity
(→ Airports.id)
11Energy efficient lighting system1000 Passengers per day
22Baggage handling system upgrade1000 Passengers per day
33Security checkpoint modernization500 Passengers per day
44Passenger lounges renovation1500 Passengers per day

Flights

idFlightNumberDepartureTimeArrivalTimeAirportID
(→ Airports.id)
1AA12306:00:0008:00:001
2BA45608:00:0010:00:002
3QF78910:00:0012:00:003
4CX12312:00:0014:00:004
5LH45614:00:0016:00:001
6MU78916:00:0018:00:002
7AE99818:00:0020:00:003
8ET12320:00:0022:00:004

Airlines

idAirlineNameHeadquartersLocationFleetSizeAirportID
(→ Airports.id)
1American AirlinesFort Worth, Texas9501
2British AirwaysWatford, Hertfordshire2802
3Qantas AirwaysMascot, New South Wales1803
4Cathay PacificHong Kong1404
5LufthansaCologne3001
6EmiratesGarhoud, Dubai2502
7AeromexicoMiguel Hidalgo1303
8Ethiopian AirlinesAddis Ababa1104