Airlines

airline_idname
1Alaskan Airlines
2Delta Airlines
3United Airlines
4Southwest Airlines
5JetBlue Airlines

Airplanes

airplane_idmodelcapacitycurrent_flight
(→ Flights.flight_id)
1Boeing 737180None
2Airbus A320160None
3Bombardier Q40065None
4Embraer E19080None
5Boeing 787250None

Flights

flight_iddeparture_timedestinationairplane_idairline_id
(→ Airplanes.airplane_id)(→ Airlines.airline_id)
12021-11-01 08:00:00Los Angeles11
22021-11-01 10:00:00New York22
32021-11-01 12:00:00Chicago33
42021-11-01 14:00:00Houston44
52021-11-01 16:00:00Dallas55

Passengers

passenger_idfirst_namelast_nameagefamily_id
(→ Families.family_id)
1JohnSmith351
2JaneDoe28None
3MichaelJohnson452
4EmilyWilliams303
5DavidBrown504

Boardings

boarding_idpriorityfamilypassenger_idflight_id
(→ Passengers.passenger_id)(→ Flights.flight_id)
11111
20022
30133
40044
50055

Families

family_idhead_of_family
(→ Passengers.passenger_id)
11
22
33
44
55