Aircrafts

idModelManufacturerYear
1Boeing 737Boeing2005
2Airbus A380Airbus2011
3Cessna Citation XCessna2006
4Gulfstream G650Gulfstream Aerospace2012
5Embraer E190Embraer2008

Flights

flightIDdepartureTimedestinationaircraftId
(→ Aircrafts.id)
109:00 AMNew York1
210:00 PMChicago2
301:00 PMDallas3
402:00 PMLos Angeles4
503:00 PMMiami5

Terminals

terminalIDname
1Terminal 1
2Terminal 2

Boards

boardIdequipmentTypeterminalId
(→ Terminals.terminalID)
1Jet Bridge1
2Mobile Lounges1
3Jet Bridge2
4Staircar2

Passengers

passengerIdfullNamedobflightId
(→ Flights.flightID)
1John Doe1990-01-011
2Jane Smith1985-05-152
3Alice Johnson1978-12-123
4Tom Brown1992-07-044
5Emma Davis1989-08-185