Airports

idname
1JFK
2LAX
3ORD
4YUL
5CDG

Hotels

airport_idhotel_nameprice
(→ Airports.id)
1Hilton250.0
1Marriott300.0
2Radisson280.0
3Hyatt350.0
4Accor270.0
5Novotel260.0

SleepPods

airport_idpod_nameprice
(→ Airports.id)
1GoSleep150.0
1RestEZ160.0
2SnoozCruz190.0
3AirPOD170.0
4DreamPOD180.0
5SlumberPOD200.0

Flights

flight_numberorigin_airport_iddestination_airport_iddeparture_timearrival_timeprice
(→ Airports.id)(→ Airports.id)
AA123122022-12-01 10:002022-12-01 14:00200.0
2232022-12-01 12:002022-12-01 16:00220.0
3132022-12-02 10:002022-12-02 14:00210.0
4342022-12-02 12:002022-12-02 16:00230.0
5452022-12-03 10:002022-12-03 14:00240.0

Passengers

passenger_idfirst_namelast_nameemail
1JohnSmithjohnsmith@example.com
2JaneDoejanedoe@example.com
3AliceWonderlandalicewonderland@example.com
4BobBuilderbobbuilder@example.com
5CharlieSheencharliesheen@example.com

Bookings

booking_idpassenger_idflight_numberhotel_idsleep_pod_idcheckin_datecheckout_date
(→ Passengers.passenger_id)(→ Flights.flight_number)(→ Hotels.id)(→ SleepPods.id)
11AA1231None2022-12-012022-12-03
22BB456212022-12-022022-12-04
33CC789322022-12-032022-12-05
44DD012432022-12-042022-12-06
55EE345542022-12-052022-12-07