A simple PL/SQL project that impliments few functionalities of a Airline Reservation System.
This system has different features for passenger site and customer site. Following are some features of both module.
Passenger Module:
- Create Account: Passenger can create an account providing necessary details.
- Login/logout: Passenger can login to the system by providing their email and password.
- View Passenger Detail: Passengers can view their personal info and previous flight details.
- View Flight Info: Passengers can view flight info for a particular date or destination. This also allows user to view the time table for the flight.
- Ticket Reservation: This allows customer to book a ticket which is user friendly and can be accessed easily
- View Reservation History: User can view his/her flight reservation and get necessary details about the flight.
- Reservation Cancellation: This allows passengers to request for cancellation of their reservation and avail refund.
Administrator Module:
- Login/logout: Administrator can login to the system by providing their administrator id and password.
- Passenger Management: Add/Delete/Update customer information.
- Flight Management: This allows administrator to manage flight information.
- Airbus Management: Administrator can manage airbus information through this.
- Reservation Cancellation Management: This allows administrator to manage the requested reservation cancellation.
- Add New Administrator: This allows to create a new administrator account
OS: Windows/Linux/MAC
Programming Language: PL/SQL
Tools: Oracle 10g, SQL *PLUS, Notepad, Sublime Text 3
Customer registration
Customer login
Showing available aircrafts and flights
Book a flight from customer end
Showing booking history
Cancel booking by customer
Showing the cancelled booking which are pending for admin's approval
Showing income from each flight and the total income earned
