Flight

flightIDdepartureTimearrivalTimeaircraftIDterminalID
(→ Aircraft.aircraftID)(→ Terminal.terminalID)
12023-01-01 07:00:002023-01-01 10:00:0011
22023-01-01 09:00:002023-01-01 11:00:0021
32023-01-01 11:00:002023-01-01 13:00:0032
42023-01-01 14:00:002023-01-01 16:00:0041
52023-01-01 16:00:002023-01-01 18:00:0052

Passenger

passengerIDfirstNamelastNameflightIDloungeID
(→ Flight.flightID)(→ Lounge.loungeID)
1JohnDoe11
2JaneSmith21
3AliceBrown32
4MichaelJohnson41
5EmilyWhite52

Aircraft

aircraftIDmodelcapacity
1Airbus A320200
2Boeing 737180
3Embraer E190100
4Airbus A380500
5Boeing 777350

Terminal

terminalIDlocation
1Terminal 1
2Terminal 2

Lounge

loungeIDnameexclusiveAreaamenitiescapacityterminalID
(→ Terminal.terminalID)
1Business Class LoungeFrequent Flyer LoungeComplimentary Wi-Fi1001
2Premium Economy LoungeFrequent Flyer LoungeNot Complimentary Wi-Fi801
3First Class LoungeVIP LoungeComplimentary Wi-Fi502
4Golden Wings LoungeVIP LoungeNot Complimentary Wi-Fi602
5Silver Stars Lounge401

Amenity

amenityIDdescription
1Free high-speed internet access
2Power outlets at every seat
3Quiet zones for relaxation
4Children's play area
5Showers facilities