## Airports

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

## Expansions

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

## Renovations

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

## Flights

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

## Airlines

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