Flights

FlightIDOriginDestinationDepartureTimeArrivalTimeAirlineIDPlaneID
(→ Airlines.AirlineID)(→ Planes.PlaneID)
1SeattleNew York2023-04-01 10:00:002023-04-01 14:00:0011
2Los AngelesChicago2023-04-01 12:00:002023-04-01 16:00:0022
3San FranciscoHouston2023-04-01 14:00:002023-04-01 18:00:0033
4DallasAtlanta2023-04-01 16:00:002023-04-01 20:00:0044
5MiamiPhiladelphia2023-04-01 18:00:002023-04-01 22:00:0055

Passengers

PassengerIDNameAgeBoardingTypeFlightID
(→ Flights.FlightID)
1John Doe35Priority Boarding1
2Jane Smith28Family Boarding1
3Emily Johnson32Priority Boarding2
4Robert Brown40Family Boarding2
5Tom Wilson25Priority Boarding3
6Linda Davis30Family Boarding3
7David Miller22Priority Boarding4
8Sarah Taylor28Family Boarding4
9Mark Lee35Priority Boarding5
10Laura Kim30Family Boarding5

Planes

PlaneIDModelCapacity
(→ Flights.PlaneID)
1Boeing 737200
2Airbus A380519
3Embraer E190100
4Bombardier CRJ900100
5Boeing 747600

Airlines

AirlineIDName
1Alaskan Airlines
2United Airlines
3Delta Airlines
4Southwest Airlines
5American Airlines