Airline Reservation System Project Proposal, Assignments of Computer Science

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

2019/2020

Uploaded on 11/26/2020

sagun-khadka
sagun-khadka 🇳🇵

5

(1)

5 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Project Proposal
1. Introduction
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.
2. Problem Statement
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.
pf3
pf4
pf5

Partial preview of the text

Download Airline Reservation System Project Proposal and more Assignments Computer Science in PDF only on Docsity!

Project Proposal

1. Introduction

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.

2. Problem Statement

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.

3. Objectives

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.

4. Methodology

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

5. Gantt Chart

6. Expected Outcome

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.

7. References

(www.wikipidia.com), (www.quora.com), (www.stackoverflow.com)