We would like to take this opportunity to express our gratitude
towards all the people who have in various ways, helped in the successful
completion of our project. We must convey our gratitude to those peoples
who gave the constant source of inspiration and help in preparing the
project, personally correcting our work and providing encouragement
throughout the project.
We also thank Mr. Anurag Yadav (our project guide) for steering us
through the tough as well as easy phases of the project in a result
oriented manner with concern attention.
We would also like to express our sincere thanks to my college
F.E.T. Agra College for giving us this opportunity.
Vinay Pratap Singh
Table of Contents
iii. Requirement Analysis
iv. Feasibility Study
v. System Design
vi. Implementation Details
ix. Future works
The introduction of our problem lies in manual system and a fully
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
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 direct us to develop a new system are given below -:
1) Faster System
5) Reservations and cancellations from anywhere to any place
More and more travelers, particularly among the younger generation
that has grown up with the Internet, are turning to online reservation
systems to make their flight arrangements. There's a logical reason for this.
Booking a flight online is faster and more convenient, gives you more
freedom to comparison shop and is usually a little cheaper than the
traditional methods - calling a travel agent or contacting the airline directly.
A computer reservations system (CRS) is a computerized system used to
store and retrieve information and conduct transactions related to air travel.
Originally designed and operated by airlines, Major CRS operations that book
and sell tickets for multiple airlines are known as global distribution systems
(GDS). Airlines have divested most of their direct holdings to dedicated GDS
companies, who make their systems accessible to consumers
through Internet gateways.
Our project is based on this problem that how can we make online
Airline reservation faster, easier and accurate. 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 Global Distribution System.
1. Adobe Photoshop
2. Wamp Server (Windows), Lamp Server (Unix)
3. SQL Server
4. Web Browser to run programs
5. Any Platform (Windows, Unix, Macintosh)
6. Text editor e.g. Notepad for Windows
1. System Pentium-IV 2.4 GHz
2. RAM - 64 MB or higher
3. HDD - 512 MB min.
4. Keyboard, Mouse
Feasibility study is to check the validity of the project under
consideration. Theoretically various types of feasibilities are conducted, but
we have conducted three type of feasibilities explained as under.
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 10 lacks P.A. Hence the new system is
The new system requires only 4 trained people to work with the system
and in overall 10 people per office is sufficient. So we will identify 4 best
people from existing system and train them.
As our existing system is purely manual, so we need a onetime
investment of Rs. 4 Lacks for the purchase of 5 computers, 5 Ticket printers,
a laser printer, AC and networking etc. It requires 10 Lacks PA as an operating
cost. With the above details our system is technically feasible as after
investing 15 lacks in a year, the company is still saving about Rs 25 Lacks PA.
The new solution is feasible in all sense but operationally it is not. The
new system demands the expulsion of at least 15 people from the company.