A
PROJECT REPORT
ON
AIRLINE TICKET
RESERVATION
Submitted in partial fulfillment of
the requirement for the degree of
BCA (Final Year)
(2011-2014)
Under guidance of : Submitted By :
MR. SHAILENDRA SHARMA ANUJ RANA
HOD BCA (IIIrd Year)
Roll. : 9675014
2011-2014
COLLEGE OF APPLIED EDUCATION & HEALTH SCIENCE
Meerut (U.P.) – 250001
COLLEGE OF APPLIED EDUCATION &
HEALTH SCIENCE, MEERUT (UP)
CERTIFICATE
This is to certify that ANUJ RANA student of BCA
(Final Year) Batch (2011-2014) has completed his
project work on AIRLINE TICKET RESERVATION
during the year.
Director
COLLEGE OF APPLIED EDUCATION &
HEALTH SCIENCE NUTRITION, MEERUT (UP)
HOD NOTE
I am pleased to mention that ANUJ RANA student
of COLLEGE OF APPLIED EDUCATION & HEALTH
SCIENCE, MEERUT has successfully completed his
project work on AIRLINE TICKET RESERVATION
under my supervision during the year.
HOD
ACKNOWLEDGEMENT
A Project like this cannot be completed without help
and advice from different services. This project has
been made possible through direct and indirect co-
operation of various people for whom we wish to
express our appreciation and gratitude.
First and foremost I am thankful to academic and
administrative members of the CAEHS family, for giving
us a chance to work on this project, We are thankful to
the teachers of BCA for enabling us to purse our
studies and attain this vast knowledge.
I am thankful to My Director and HOD for their
valuable suggestion and guidance.
Date :
Place : ANUJ RANA
ABSTRACT
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.
LIST OF TABLES
Cancellation table
Classes table
Flight days
Flight Details
Login
Mail
New User
Passenger
Payment
Reservation
LIST OF FIGURES:
Class DiagRANA
Activity DiagRANA
Sequence DiagRANA
Use Case DiagRANA
Collaboration DiagRANA
CONTENTS
S.N. Topic
1. Introduction
2. Overview of Proposed system
2.1 Exiting System
2.2 Proposed System
3. System Analysis
3.1 Front End
3.2 Back End
3.3 Modules
4. System Design
4.1 UML
4.1.1 Class DiagRANA
4.1.2 Activity DiagRANA
4.1.3 Sequence DiagRANA
4.1.4 Use Case DiagRANA
4.1.5 Collaboration DiagRANA
4.1.6 Dataflow
4.2 Data Dictionary
4.2.1 Introduction
4.2.2 Data Dictionary
5. Implementation
6. Experimental Results
7. Testing
7.1 Introduction
7.2 Type of Testing
7.2.1 Unit Testing
7.2.2 Integrated Testing
7.2.3 Recovery Testing
7.2.4 Security Testing
7.2.5 Performance Testing
7.2.6 White-box Testing
8. Conclusion
9. References