Flights

FlightIDAirlineDestinationDepartureTimeArrivalTime
1United AirlinesNew York10:30 AM12:00 PM
2Delta AirlinesLos Angeles9:00 AM11:00 AM
3American AirlinesChicago7:00 AM9:00 AM
4Southwest AirlinesDallas6:30 AM8:00 AM
5JetBlue AirlinesMiami5:00 AM7:00 AM

BaggageClaims

ClaimIDFlightIDLocation
(→ Flights.FlightID)
11Terminal 2
22Terminal 3
33Terminal 1
44Terminal 2
55Terminal 4

SecurityChecks

CheckpointIDFlightIDLocationTime
(→ Flights.FlightID)
11Terminal 28:00 AM
22Terminal 37:00 AM
33Terminal 16:00 AM
44Terminal 24:00 AM
55Terminal 43:00 AM

Passengers

PassengerIDNameAgeNationality
1John Doe30USA
2Jane Smith25UK
3Alice Johnson28Canada
4Tom Brown45Australia
5Emily Davis35Germany

Bookings

BookingIDPassengerIDFlightIDClassPrice
(→ Passengers.PassengerID)(→ Flights.FlightID)
111Economy250
212Business1000
323Premium Economy500
434Economy250
545First Class3000