Bookings Data Base ER diagram
This ER diagram shows the main entities and foreign key relationships for the Bookings database.
Bookings Database ERD
Entity relationship diagram for the Bookings database with 8 main tables and key foreign key relationships.
aircrafts_data
PK
aircraft_code
model
range
aircraft catalog
airports_data
PK
airport_code
airport_name
city
coordinates
timezone
flights
PK
flight_id
flight_no
scheduled_departure
scheduled_arrival
FK
departure_airport -> airports_data
FK
arrival_airport -> airports_data
FK
aircraft_code -> aircrafts_data
status
actual_departure
actual_arrival
bookings
PK
book_ref
book_date
total_amount
seats
PK
FK
aircraft_code
PK
seat_no
fare_conditions
ticket_flights
PK
FK
ticket_no -> tickets
PK
FK
flight_id -> flights
fare_conditions
amount
ticket to flight map
boarding_passes
PK
FK
ticket_no
PK
FK
flight_id
boarding_no
seat_no
check-in data
tickets
PK
ticket_no
FK
book_ref -> bookings
passenger_id
passenger_name
contact_data
Legend
PK
Primary key
FK
Foreign key
Child table points to parent table
One connector line per FK
No connector through table bodies
N:1
N:1
N:1
N:1
N:1
N:1
N:1
N:1