The Flight Reservation System is a software application developed using C# that enables users to book, cancel, and modify flights. This system simplifies the airline reservation process by allowing customers to easily search and book flights based on their preferred travel dates, source, and destination. The system also provides administrators with the ability to manage aircraft, flights, and customers.
-
User Management
- Signing up a new user (admin or customer)
- Updating user details
-
Aircraft Management (Admin only)
- Adding an aircraft
- Updating aircraft details
-
Flight Management (Admin only)
- Adding a flight
- Updating flight details
-
Flight Search and Booking
- Showing a list of available flights based on criteria (date, source, destination, required number of seats)
- Performing operations on flights: booking, canceling, changing flight class
The Flight Reservation System uses MS SQL Server as the database management system. The database includes tables for User, Aircraft, Flight, Reservation, and Payment, which are created based on the physical ERD. The tables are linked through foreign keys, and the relationships between the tables correspond to the relationships in the conceptual ERD. The database is updated whenever there is a new reservation, cancellation, or modification to a flight.
The application program implemented using C# includes the following features:
-
Insert Operations
- 2 insert statements on 2 different tables
-
Delete Operations
- 2 delete statements on 2 different tables (with conditions)
-
Update Operations
- 2 update statements on 2 different tables (with conditions)
-
Data Retrieval
- Select data from any tables of the database
- Select data that involves more than one table of the database (using joins)
-
Report Generation
- Generation of meaningful reports
-
User Interface
- Implementation of a GUI
Here are some screenshots of the application in action:
)
