Full Wiki

An airline reservation system is part of the so-called passenger service systems (PSS), which are applications supporting the direct contact with the passenger.
The airline reservations system (ARS) was[when?] one of the earliest changes to improve efficiency. ARS eventually evolved into the computer reservations system (CRS). A computer reservation system is used for the reservations of a particular airline and interfaces with a global distribution system (GDS) which supports travel agencies and other distribution channels in making reservations for most major airlines in a single system

PROBLEM DEFINITION

The definition of our problem lies in manual system and a fully automated system.

Manual system : The system is very time consuming and lazy. This system is more prone to errors and sometimes the approach to various problems is unstructured.

Technical system : With the advent of latest technology if we do not update our system then our business result in losses gradually with time. The technical systems contains the tools of latest trend i.e. computers printers, fax, Internet etc. The systems with this technology are very fast, accurate, user-friendly and reliable.

Need of Airlines system
A few factors that directs us to develop a new system are given below -:
1) Faster System
2) Accuracy
3) Reliability
4) Informative
5) Reservations and cancellations from any where to any place

FEASIBILITY STUDY

Feasibility study is to check the viability of the project under consideration. Theoretically various types of feasibilities are conducted, but we have conducted three type of feasibilities explained as under.

ECONOMIC FEASIBILITY
With the manual system the operating cost of the system is about 60 Lacks P.A.. This cost comprises salary of 25 people, stationary, building rent, electricity, water, telephone etc. But with the new system this reoccurring cost comes out to be about 20 Lacks P.A. Hence the new system is economically feasible.

TECHNICAL FEASIBILITY
The new system requires only 6 trained person to work with the system and in overall 10 people per office are sufficient. So we will identify 6 best people from existing system and train them.

As our existing system is purely manual, so we need a one time investment of Rs 4 Laks for the purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20 Lacks PA as a operating cost.

With the above details our system is technically feasible as after investing 24 Lacks in a year, the company is still saving Rs 25 Lacks PA.

OPERATIONAL FEASIBILITY

The new solution is feasible in all sence but operationally it is not. The new system demands the expulsion of at least 15 people from the company. It creates an environment of joblessness and fear among the employees. It can lead to an indefinite strike in the company also. So the management must take corrective actions prior in advance in order to start the further proceedings.

SYSTEM ANALYSIS

This was the most important phase of my project life cycle .It had connected my maximum time .The block diagram given bellow depict various fact which were understood by one during the analysis phase.

BLOCKDIAGRAM

    In that phase initially I had observed the system by visiting to Indiragandhi Airport(domestic terminal)      and a few airline reservation agency.

Pardes Airline agencies , Lotus Airline agencies.

                  The above block diagram is an implementation of this observation .

In the next phase I had various quiries in my mind ,Which I tried to ask from appropriate authorities A sample of my quires is enclosed as Annex 1.

Q.1 Tick mark the features to be included in the new system?
• Enquiry
• Reservation
• Cancellation
• Report
• Edit
• Other specify

Q2. Tick mark that the system should be ?

• Multi-user
• Single user

Q3. Tick marks the total time required for the implementation of the project?
• 3 months
• 6 months
• 9 months
• Others specify

Q4. Tick mark the reports to be Incorporated?
• List of all passenger
• List of all flights
• List of passenger(date wise)
• List of passenger(flight wise)
• Any other

After getting solution my queries I started studying database structure used in the existing system . In this connection I had come to know about various master files as

.

. 4.SYSTEM DESIGN

In this phase initially I had designed E-R diagram of the processes , in order to identify various entities and relation ship set ,entity set ,attributers, link attributes The Diagram of this process as under.
After this step We had tried design the data base for the new system and normalized it
The tables motivated in data dictionaries enclosed as annex II is an out come of this step

The symbol of entities are shown bellow

E-R DIAGRAM FOR BOOKING DEPARTMENT

DATA FLOW DIAGRAM

In order to design a better solution. I had designed the DFD for system including all technical processing details is given bellow

LEVEL 0 DATA FLOW DIAGRAM

LEVEL 1 DATA FLOW DIAGRAM OF GENERAL ENQUIRY SYSTEM

LEVEL 1 DATA FLOW DIAGRAM OF PASSENGER ENQUIRY
SECTION

LEVEL 2 DFD OF BOOKING

LEVEL 2 DFD OF CANCELLATION

ALGORITHM

In this phase further I had designed algorithms for various technical sub problem a few than are enclosed here with.
RESERVATION

• A PERSON COME TO RESERVED ATICKET.

• THEN HE GIVES HIS FULL DETAILS

• IN CUSTOMER FORM THOSE DETAILS WERE WRITTEN.

• THEN COMPUTER CHEQUE THE DATE WHAT DATE THE PERSON RESER VED

• DATE WISE IT CHEQUE THE FLIGHTS

• IF THE FLIGHT IS FLING THAT DAY

• THEN SYSTEM JUSTIFY THE SPECIFIC FLIGHT ID

• IT CHEQUE ITS SEAT CLASS.

• IF THE PASSENGER WANT TO ECONOMIC CLASS AND WINDOW SIDE SEAT

• THEN SYSTEM CHEQUE IF THERE ANY SEAT IN ECONOMIC CLASS WHICH IS INSIDE THE WINDOW

• IF SEAT IS EMPTY THEN SYSTEM RESERVED THE SEAT .

• THEN TICKET IS GENERATED.

• THE TICKET IS CONFIRMED.

• IF THE CONDITION IS NOT APPLIED THEN IT CHEQUE NEXT SEAT

• AND JUSTIFIED IT .

• IF IT IS NOT ALSO EMPTY THEN IT CHEQUE NEXT BY NEXT.

• IF THERE IS NO SEAT THEN SYSTEM TAKE TICKET WHICH IS NOT CONFIRMED

• THEN IT GIVE WAITING LIST.

• END.

                               INPUT  SCREEN

As a last step in design phase I had designed various Input and out put inter phase screen .The sample format of this screens is enclosed in annex III..

THIS IS A PICTURE OF THE MAIN MENU.

In this picture there are three parts . Those are master file, ticket , report,
When we click in master file then it show six forms those are custodial , concession
Flight info , fleet info, fare ,payment . when we click any one of this then the form is
Open. Now we open each file one by one.