Airline Reservation DB
It is a database designed to manage fights of a ticket agent named "Fly Safe Airways International" based in New York. The company has been providing their booking services since 1997. The database consists of 15 following tables:
- Airlines_Master: details of airline companies
- Category_master: the classification (Domestic or International) airlines
- Class_master: the classes of ticket: First class, Economy, or Executive
- City_master: departure and destination cities
- Day_master: days of week having flights
- Meal: options of meals served on board
- Service: services provided on board
- Status_master: the status of ticket
- Airline_Service: which services are provided by an airline?
- Airline_meal: which meal are provided by an airline?
- Flight: flights of airlines
- Flight_days: which day does a flight operate?
- Flight_details: the details of flights
- Passenger: details of passengers
- Reservation: details of reservations.
Click AirlineReservation.sql link to view the file.