Flights

FlightIDDepartureTimeDestinationAircraftID
(→ Aircraft.AircraftID)
110:00New York1
212:00Los Angeles2
314:00Chicago3
416:00Dallas4
518:00Atlanta5

Passengers

PassengerIDNameAge
1John Doe35
2Jane Smith27
3Alice Johnson43
4Bob Brown56
5Emma Wilson29

Aircraft

AircraftIDModelCapacity
1Boeing 737160
2Airbus A320180
3Embraer E190100
4Bombardier CRJ70070
5Cessna Citation XLS+8

Staff

StaffIDFirstNameLastNameRole
1TomHanksPilot
2RobertDowney Jr.Co-pilot
3KeiraKnightleyFlight Attendant
4MarkRuffaloGround Staff
5ScarlettJohanssonCustomer Service

MobilityAids

MobilityAidIDTypeAvailable
1Wheelchair Assistance1
2Mobility Scooter0
3Portable Oxygen Concentrator1
4Walking Sticks1
5Electric Wheelchairs0

Locations

LocationIDDescriptionIsPickUpDropOff
1Entrance A1
2Gate B0
3Gate C0
4Curbside Check-in1
5Security Checkpoint0

OfferedServices

ServiceIDMobilityAidIDLocationID
(→ MobilityAids.MobilityAidID)(→ Locations.LocationID)
111
212
321
422
531