A relational database system for managing airlines, airports, flights, passengers, tickets, flight classes, and airline inventory.
This database schema is designed for managing airline inventory and operational data, providing a structured system for tracking airlines, airports, flights, passengers, tickets, and flight classes. It establishes relationships between essential airline records to support accurate scheduling, passenger management, ticketing, seat availability, and efficient airline operations.
Oh and I used https://app.diagrams.net/ to create the diagrams.
You can reupload the existing ones in the .draw.io file.