AIRLINE RESERVATION

A Project Report Submitted in partial fulfillment of the requirements for the summer Project Of

Bachelor of Computer Application In Department of Computer Application By

Department of Computer Application University Institute of Engineering & Technology

2010

University Institute of Engineering & Technology CSJM University Kanpur

Department of Computer Application CERTIFICATE

This is to certify that the project work entitled Airline reservation is being submitted by Deeksha Sharma Roll no:B80038 and Eti Katiyar Roll no:B80049 in partial fulfillment for the award of Degree of BACHALAR OFCOMPUTER APPLICATION in Department of computer application to the University Institute of Engineering & Technology, CSJM University, Kanpur during the academic year 2009-10 is a record of bona-fid e work carried out by him under our guidance and supervision.

The results embodied in this report have not been submitted by the students to any other University or Institution for the award of any degree or diploma .

Project Guide Mr.Shekhar Verma

Head of Department Mrs. Mamta Tiwari

ACKNOWLEDGEMENT

I expressed my deep sense of gratitude to my beloved Director (University Institute of Engineering & technology) for the valuable guidance and for permitted us to carry out this project .

I expressed my deep sense of gratitude to my beloved faculty Mrs. Shekhar Verma, Computer Application Department for the valuable guidance and suggestion, keep interest and through encouragement extended throughout period of project work.

With gratitude,
1-Deeksha Sharma 2- Eti Katiyar

SYNOPSIS

The Airline Reservations System (ARS) was 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 which supports travel agencies and other distribution channels in making reservations for most major airlines in a single system.

Airline Reservations Systems contain airline schedules, fare tariffs, passenger reservations and ticket records. An airline's direct distribution works within their own reservation system, as well as pushing out information to the GDS. A second type of direct distribution channel is consumers who use the internet or mobile applications to make their own reservations.

There are 5 modules in this project.

1. Administrator Module.

Enables the airline administrator to perform all administrative functions and manage inventory over LAN or the Internet. The administrator can modify routes, fares, schedules and assign or deny access rights for qualified travel agents and other authorized users.

2. Reservation Agent Module.

Allows the airlines reservation agents to make and modify reservations on the LAN or over the internet. The reservation agents could be stationed at any airline office location.

3. Passenger Module.

This module enables online customers to make reservations, view their bookings, make special service requests and define their preferences over the web.

4. Payment.

Provides the airline with the ability to set up various travel agents and give them reservations capabilities over the Internet. The travel agents are able to display and offer discounted fares to passengers.

5. Cancellation.

The system should allow the user to cancel the existing booking. In this system cancellation is very helpful to all the travelers.

INTRODUCTION

DISCRIPTION OF PROJECT

Airline reservation systems were first introduced in the late 1950s as relatively simple standalone systems to control flight inventory, maintain flight schedules, seat assignments and aircraft loading. The modern airline reservation system is comprehensive suite of products to provide a system that assists with a variety of airline management tasks and service customer needs from the time of initial reservation through completion of the flight. One of the most common modes of travel is traveling by air. Customers who wish to travel by air nowadays have a wide variety of airlines and a range of timings to choose from. Nowadays competition is so fierce between airlines that there are lot of discounts and a lot of luxuries given to customers that will give an edge to that particular airline.

The World Wide Web has become tremendously popular over the last four years, and currently most of the airlines have made provision for online reservation of their flights. The Internet has become a major

resource for people looking for making reservations online without the hassle of meeting travel agents. My Project intends to serve these purposes. It intends to check all the available airline databases and return a string of results, which can help them in their travel plans.

The objective of this project is to create an airline reservation system where a traveler can request all flight information as per their journey dates. They can get information regarding time, cost, etc all at the same time and place. When the customer calls the Counter Assistant for his/her travel needs, the counter assistant will enter the customer's details (flight requirements) in the system. The system displays all the available airlines, schedules and prices. This system would help the airline to better serve its customers by catering to their needs. The site would use a Database to hold this information as well as the latest pricing and availability information for the airlines.

Key Features:

* Web-based reservation engine with a user friendly graphical interface * Individual and group level authorization access * Reservation supervisor overriding * Integrated departure control system * Passenger communication features * Comprehensive management reporting capabilities

SYSTEM REQUIREMENT SPECIFICATION

SYSTEM REQUIREMENT SPECIFICATION To develop a new system certain hardware and Software specifications are needed.

2.1 HARDWARE SPECIFICATION

System Processor Speed Memory Hard Disk Drive

: IBM-Compatible PC and above : Pentium IV and above : 2.0 GHZ and above : 256 MB RAM and above : 20 GB and above

2.2 SOFTWARE SPECIFICATION

Operating System Development environment Language used Front end Back end

: Windows XP and above : eclipse : turbo C++ : turbo C++ : DOS file support

2.3 OVERVIEW OF THE PROJECT

The main purpose of this software is to reduce the manual errors involved in the airline reservation process and make it convenient for the customers to book the flights as when they require such that they can utilize this software to make reservations, modify reservations or cancel a particular reservation The name of the software is AIRLINE RESERVATION SYSTEM. This software provides options for viewing different flights available with different timings for a particular date and provides customers with the facility to book a ticket, modify or cancel a particular reservation but it does not provide the customers with details of cost of the ticket and it does not allow the customer to modify a particular part of his reservation and he/she can modify all his details.

There are 5 modules in this project. 1. Administrator Module.

Enables the airline administrator to perform all administrative functions and manage inventory over LAN or the Internet. The administrator can define or modify routes, fares, schedules and assign or deny access rights for qualified travel agents and other authorized users.

2. Reservation Agent Module

Allows the airlines reservation agents to make and modify reservations on the LAN or over the internet. The reservation agents could be stationed at any airline office location.

3. Passenger Module.

This module enables online customers to make reservations, view their bookings, make special service requests and define their preferences over the web 4. Payment. Provides the airline with the ability to set up various travel agents and give them reservations capabilities over the Internet. The travel agents are able to display and offer discounted fares to passengers.

5. Cancellation.

The system should allow the user to cancel the existing booking. In this system cancellation is very helpful to all the travelers.

DATA FLOW DAIGRAMS

DATA FLOW DAIGRAM

0LEVEL DFD

Airline

User

Reservation
System

Output

1LEVEL DFD

User

Airline Reservation System

Exit

Add View Reservation details

Ticket
View

Search

Passenger

Delete

Search Search

Add

View

Delete

ER-DAIGRAME

E-R DAIGRAM

S no.

Flight no.

Reservation

Source Destination Economic Fair Executive Fair Ticket no.

Airline Reservation

Flight no. Ticket Source Destination Passenger name Address Age Sex Flight no.

Total Fair

Passenger

Ticket no. No. of passengers

Total Fair Destination

Source Class name Sex Age

Passenger name Address

DATABASE TABLES

DATABASE TABLES

1-RESERVATION
This table is used to store reservation details

FIELDNAME S no. Flight no Source Destination Total fair Class name

DATATYPES int Char[10] Char[15] char[15] int ecofair[10] exefair[10] char

2-CANCELLATION
This table is used to store cancellation details

FIELDNAME Ticket no. Passenger name Flight no. Passenger age Total fair Source Destination Passenger sex Passenger address

DATATYPES int Char[26] Char[10] int int ecofair[10] exefair[10] Char[15] Char[15] Char Char[36]

3-PASSENGER
This table is used to store list of passengers

FIELD NAME Ticket no. Flight no. Passenger name class

DATATYPES int Char[10] Char[26] Char

4-PASSENGER RECORDS
This table is used to store records of passengers

FIELDNAME Ticket no. Flight no. Passenger name Passenger age Passenger address Source Destination Passenger sex Total fair

DATATYPES int Char[10] [26] int Char[36] Char[15] Char[15] Char int ecofair[10] exefair[10]

INPUT FORMS AND OUTPUT REPORT

APPLICATIONS

APPLICATIONS

There are many fields where this system is used which are as given below:

This system enables the airline administrator to perform all administrative functions and manage inventory over LAN or the internet.

This System allows the airlines reservation agents to make and modify reservations on the LAN or over the internet. The reservation agents could be stationed at any airline office location.

Passenger module enables online customers to make reservations, view their booking, make special service requests and define their performances over the web. The system provides the airline with the ability to setup various travel agents and give them reservations capabilities over the internet. The travel agents are able to display and offer discounted fares to passengers. The system should allow the user to cancel the existing booking. In this cancellation very helpful in all the travelers.

TRUE SCOPE AND IMPROVEMENT

TRUE SCOPE AND IMPROVEMENT

Developments in software technology are continuing dynamically. This has forced software developers to look for new approaches to software design and development. In order to face this situation, the modules in a package should be tolerant to change in any time. The modules in this package can be subjected to further enhancements. We can send information to customers regarding new schemes. More other reports can be produced and new variations can be drawn up. This is also meant to be the foundation stone for something that scales the largest pinnacles of excellence and the developers sincerely believe that, this project has been realized.

In future of the scope of this project is that it can be used 1n Air Line Reservation Company and institute and will help the institute in the following way:

Can store information of passengers. Presences of option like Add, Delete, Search, and Display also are help for the users. The system is highly flexible one and is well efficient to make easy interaction with the client. The speed and accuracy will be maintained in a proper way. This will be user friendly one and can successfully. The system will be a flexible one and changes whenever can be made easy. Using the facility and flexibility in C++, the software can be developed in a neat and simple manner there by reducing operators work. Data can be stored in huge amount in this problem i.e. no problem of space. Since the project is developed in C++, it can be modified easily, and used for long period.

CONCLUSION

To various processes to fulfill the requirements proposed during the analysis phase in the development of this project have been completed. The package was validated for accuracy and the results were found to be satisfactory. An instruction can implement the project and even modify it according to its changing need and necessities. Top down programming techniques has been adapted while developing the system. Each task is divided into modules. The modules developed can be easily linked to the system. Hence the new system is more reliable, accurate, efficient, and effective.

REFERENCE

Name of Book Mastering C++ Let us C

Publication Tata McGraw Hill BPB