Final Project - CS195
Date: 12/04/2023
Prepared by: Corbin Hastings & Nate Rengo
This project is a relational database system built in MySQL for managing the operations of a fictional airline. It provides a structured and optimized way to store and track essential airline data, including flights, passengers, employees, aircraft, and ticketing.
The airline requires a centralized database to efficiently manage employees, passengers, flights, and ticket sales. This system provides:
- Reliable data storage
- Efficient query execution
- Improved operational workflow
- Airline Employees: Managing flights, ticketing, and scheduling
- Analysts: Extracting insights on performance and operations
The system stores data on:
- Employees (pilots, attendants)
- Customers (passenger profiles)
- Aircraft (fleet details)
- Flights (schedules, routes)
- Tickets (purchases, seat assignments)
- Airports (origin/destination details)
- Corbin Hastings
- Nate Rengo