Databases

Airline Flight Schedules and Seat Maps Schema

ER Diagrams · made in Skemio

ER diagram showing aircraft models, seats, flights, flight seats, bookings, and baggage checks relationships.
ER diagram showing aircraft models, seats, flights, flight seats, bookings, and baggage checks relationships.
Open it in SkemioMake your own

What it shows

  • Decouple static aircraft cabin layouts from specific scheduled flight legs.
  • Represent physical seats per flight as stateful booking inventory.
  • Link baggage tags to ticket reservations rather than bare aircraft rows.

The takeaway

Never store seat availability on the physical cabin layout; allocate availability per scheduled flight leg.

More er diagrams