Airports

airportIdcityIdnamecountry
11JFKUSA
22LAXUSA
33LHRUK
44CDGFrance
55AUHUAE

Cities

cityIdnamepopulation
1New York City8600000
2Los Angeles3970000
3London9400000
4Paris2140000
5Abu Dhabi1500000

AirportCity

airportIdcityId
(→ Airports.airportId)(→ Cities.cityId)
11
22
33
44
55

Boarding_Areas_Gates

areaIdgateId
(→ Boarding_Areas.areaId)(→ Gates.gateId)
11
12
23
24
35
21
31
41
51

Boarding_Areas

areaIdlocationcapacity
1Area A10000
2Area B12000
3Area C11000
4Area D13000
5Area E10000

Gates

gateIdgateName
1Gate_A1
2Gate_B2
3Gate_C3
4Gate_D4
5Gate_E5