



Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A project proposal for an airline reservation system. The system aims to automate the process of searching for flights, making reservations, and managing cancellations. a problem statement, objectives, methodology, and expected outcomes. The system will be developed using HTML, JavaScript, CSS, and SQL server. The document also includes a high-level design of the system and a reference list.
Typology: Assignments
1 / 5
This page cannot be seen from the preview
Don't miss anything!




The web based “Airline Reservation System” project is an attempt to stimulate the basic concepts of airline reservation system. The system enables the customer to do the things such as search for airline flights for two travel cities on a specified date, choose a flight based on the details, reservation of flight and cancellation of reservation. The system allows the airline passenger to search for flights that are available between the two travel cities, namely the “Departure city” and “Arrival city” for a particular departure and arrival dates. The system displays all the flight’s details such as flight no, name, price and duration of journey etc. After search the system display list of available flights and allows customer to choose a particular flight. Then the system checks for the availability of seats on the flight. If the seats are available then the system allows the passenger to book a seat. Otherwise it asks the user to choose another flight. To book a flight the system asks the customer to enter his details such as name, address, city, state, credit card number and contact number. Then it checks the validity of card and book the flight and update the airline database and user database. The system also allows the customer to cancel his/her reservation, if any problem occurs.
Every Airline company is charged with the responsibility of ensuring to give safe and comfortable service for its customers. To ensure this quality of service, the companies which works on this business should reach to their customers and give a quality service to compute in the market. And this include easy ticket reservation and cancelation system. In the manual system, the daily reservation list for all flights is generated and sent. Very often, they cannot put up the reservation list on time. Owing to the inefficiencies in the manual system, when passengers cancel tickets, the reservation list is not updated in time. They maintain a waiting list, which is used to update the reservation list when passengers cancel tickets. Currently, the manual system handles all requests for changes in reservation. It treats a change of this kind as a cancellation, and reissues tickets. Reservation opens few days before the scheduled departure date. Based on the availability of seats the tickets are issued. Each ticket, whether confirmed or waitlisted, has a unique identification number. This number is generated in a serial order. The reservation clerk records the amount of fare paid for the ticket in Cash Collection Register. A passenger can cancel tickets by submitting a cancellation form with the ticket. Depending on the difference in hours between the departure and cancellation the passenger loses certain percentage of the fare.
The main objective of Airline Reservation System is: to manage the details of airlines ticket, flights, customer, banking counter, venders. to build an application program to reduce the manual work for managing the airlines ticket, flights, bookings, customer.
a. Requirement Identification i. Study of existing system Airline ticket management system has been a tough ask for the management responsible. Details of flights and passengers are maintained on paper. Three registers are maintained wherein the passenger requirements and flight details are taken care of. The 1st register caters to the flight details only. Columns are made that contain flight details such as Flight name and number, Journey destination (from – to), Distance to be traveled, Total fare and Total number of seats available. The 2 nd^ register contains the customer’s details. It carries customer information such as flight name and number, customer(s) name, number of seat(s) reserved, date of journey and destination (from – to). The 3rd^ register deals with the reservation and cancellation process. It maintains details like flight name and number, destination (from - to), date of journey and passenger list for a particular date. ii. Requirement Collection Hardware requirement: Desktop PC/ Laptop with Multi core CPU Software requirement: HTML, JavaScript, CSS SQL server developer
c. High Level Design of System
Fig: System Flowchart
By the end of the development phase, a web based application will be created eliminates the need to document the information using pen and paper and provides a unified solution by integrating the different systems that may be used for keep recording of data, retrieval of particular data is easy. We can recommend the passenger new places by seeing their travel history. Unnecessary crowd will be reduced. User and stakeholders may meet their requirement.
(www.wikipidia.com), (www.quora.com), (www.stackoverflow.com)