Flight Booking

Overview

Airline booking system schema modeling the full flight reservation lifecycle. Supports multi-leg itineraries, seat class pricing, passenger manifests, and boarding pass generation.

Key Design Decisions

• Multi-leg Flights: Booking segments model connecting flights as a single itinerary
• Seat Classes: Economy/business/first with per-class pricing and availability
• Passenger Records: PNR-style booking references with multiple passengers per booking
• Boarding Passes: Generated at check-in with gate and seat assignments

Tables

10-14 tables covering airlines, airports, routes, flights, seat classes, passengers, bookings, booking segments, tickets, and boarding passes.