Airline flight ticket booking and reservation system Project Report

PROJECT REPORT ON AIRLINE TICKET BOOKING and RESERVATION SYSTEM

DOWNLOAD 

AIRLINE TICKET BOOKING and RESERVATION SYSTEM PROJECT REPORT

AIRLINE TICKET BOOKING and RESERVATION SYSTEM PROJECT SOURCE CODE

Today I am going to provide you free Airline reservation system project report. This project report can be submitted as final year project report by BCA, MCA, MSc, BSc, B.Tech Computer science and information technology students. You can download Project report, synopsis and source code in java, PHP and asp.net from the end of this article.


In Flight booking System Project we have to keep records of flight schedules and fare tariffs, passenger personal information like name, address, phone number and ticket booking records. A Flight reservation system’s inventory contains all airlines with their available seats. Each airline has three categories of classes (e.g. First, Business or Economy class) and each category has 26 seats,
Airline Flight Reservation System Project Report with Source code


So in this Project report we have 3 main modules to develop air ticket booking system.
Registration module
Administrative module
Passenger module






1. Registration module


In registration module user has to give his details like name, address phone number etc. After registering with airline the user can log on to his/her own account and can view all flight details such as Timings of flight, Prices of ticket, Availability of seats and can book the ticket with unique ticket id. Registered user can book any number of tickets.




2. Administrative module of Online Airline reservation system


Administrative module is developed to manage the site and update the content at regular intervals, The major operations of Administrative module are:






1. Admin can Create and maintain Flight schedule, fare and timings of the Flight using administration module.


2. View the passenger list in a particular flight. And he can also view feedback of the user about the reservation system.


3. View the available seats in the airlines.


4. Cancel the tickets of any flights or users.


5. Updating the flight schedule and timings and fare.


Below is the use case diagram of Airline reservation system. in this diagram you can see the functionality of the ticket reservation system and interaction of Admin with these functionality.




Figure 1- Admin- reservation system project report
3. Passenger module of Flight reservation system project



This module is developed for user. Where users can logging and manage his account like booking ticket, cancel ticket, view the schedule of airline.






· Register the passenger.


· View all flights schedules, timings, fare details and seats availability.


· Book the tickets.


· View and ticket cancellation.


· Send feedback.


Below use case diagram describe the functionality of the User Module of airline registration system project. When user comes to system for the first time he has to register to access the system. On registration screen he has to enter username and password that he can use while login to system. Only a registered user can access airline reservation system. after login user can view flight timing and availability of the flight.




Figure 2 User Module- Airline reservation system

Sponsored Links













Free Project synopsis and Final project report links are given below


Project Synopsis of Airline Reservation System


PPT of Airline reservation system project report






Project Report of Airline reservation system






Source code of airline ticket reservation systme in java, PHP, asp.net







Airline Flight ticket booking system in java can be used by BCA, MCA, BSc, MSc, computer science and information technology students.


Airline flight reservation system project helps in booking air tickets online. This project can be developed in JAVA, asp.net and PHP. When you start to develop your project, the first question that comes in your mind is on which technology I should develop my project. Should I use JAVA or .Net or PHP?







According to me it depends on your interest and you can also check that in which technology you can get job easily.

You can download project report, PPT and source code from the end of this article

When you select any Software development technology you should keep the following things in your mind.
1. Do you have good knowledge of Java or ASP.NET or PHP?
2. Do you want start career as java developer or Asp.net or PHP developer.


If you want to select JAVA to develop your final year project you should cross check java and asp.net to confirm what is more beneficial. You should ask following question with yourself.
1. Are you interested in learning java and want to develop your final year project in java?
2. Do some markets research to confirm that you can find job easily in java programing?
3. You should also keep in your mind that Performance of java in your project. Are the tools available that can help you in developing your project?
4. Does the development process is easy and fast in java for your project.

It would be much appreciated if you take advice of people with experience in both java and asp.net. They can give an overview and their own subjective view about which you should choose and why

If you are willing to develop airline reservation system project in java, you can use this project report but for that you have to do some changes in Project report in technology used section.


8.2 ER DIAGRAMS of Airline ticket Reservation system Project

Figure 1




ER DIAGRAMS of online Airline flight ticket booking system Project in java






Project Report of online flight reservation system


8.3 Tables created in database to store data of airline reservation system.





FEEDBACK TABLE – This table has 5 attribute. In this table feedback data is stored. When users send any feedback from airline reservation system then this is stored in this table in database. This feedback msg can be check by admin.







ATTRIBUTE NAME

DATATYPE

CONSTRAINTS

SAMPLE VALUES


ID

Int

Primary key

1


Name

Varchar(50)

Not null

suhas


Email

Varchar(50)

Not null

suhasravva@yahoo.com


Subject

Varchar(50)

Not null

Password


Message

Varchar(MAX)

Null

Some text message here







FLIGHT SCHEDULING TABLE- Scheduling table has the attribute like file name, number of seats and price of each seats. when admin update the schedule of the flight the it is stored in this table.







ATTRIBUTE NAME

DATATYPE

CONSTRAINTS

SAMPLE VALUE


Flightname

Varchar(50)

Primary key

Suhas


Time

Datetime

Not null

27/06/2010 6:55:00 AM


Sourcestation

Varchar(50)

Not null

HYD


Destinationstation

Varchar(50)

Not null

NEW DELHI


Seats

int

Not null

120


Price

int

Not null

1200










AIRLINE TICKETBOOKING TABLE: Ticket information is stored in this table. From this table we get the information like passenger name reserved ticket number, number of passengers etc







ATTRIBUTE NAME

DATATYPE

CONSTRAINTS

SAMPLE VALUES


Passengername

Varchar(50)

Foreign key

Suhas


Flightname

Varchar(50)

Foreign key

Kingfisher


Sourcestation

Varchar(50)

Not null

HYD


Destinationstation

Varchar(50)

Not null

DELHI


Ticketno

int

Primary key

104


Numberof paasengers

Int

Not null

3















AIRLINE USER REGISTRATION TABLE : this table contains the user credentials like user name password, gender and phone number.







ATTRIBUTE NAME

DATATYPE

CONSTRAINTS

SAMPLEVALUES


Username

Varchar2(20)

Primary key

Suhas


Password

Varchar2(20)

check

Suhas1230


First name

Number(10)

Not null

Suhas Ravva


Gender

Varchar2(20)

Not null

Male


Location

Number (20)

Not null

INDIA


Phno

Number(10)

Not null

9177761547










Below is the login form of the airline reservation system project. In login page, we have two text box, Login name and password. This is the first page when user comes to the airline booking system.

When user enter valid username and password then clicking on submit button displays user panel. If entered username is invalid, error message is displayed.

On this airline system login page there are also forgot password link. If user forgot password then he can retrieve his airline flight ticket booking system project password. Password is send to user’s email id that he has given on registration form. Admin can login from this screen to schedule flight and price of the ticket. If admin want to login to system then user has to select admin in type list box.













Figure 2 Login screen - airline flight ticket reservation system project in java


Description: This is login form for user and admin.

REGISTRATION FORM







Figure 3 - Registration form - airline flight reservation system project in javaDescription: This is registration form for registering with site, registered users will be provided with unique username and password.




Airline reservation system project in PHP




Airline reservation management system project with PHP source code for Bachelor of computer application, MCA, Bsc and MSc computer science students to submit in their final year.

Airline Reservation System Project is used to book airline tickets online. The benefits of booking flight online are save money and time. If this it is not available then you have to go to reservation counter to book the ticket. The other way of flight booking is to go to flight reservation agent shop and book ticket there. For this service agent take commission. So user has to give extra money to book the Airplane ticket. Using online flight Reservation System Project user can book ticket from any place and any time without giving any extra money. We have made our application user friendly, accurate and fast. User can book ticket of any airline in few second

Sponsored Links




Use can be registered to ticket reservation management project from login page. Only a registered user can login to airline ticket booking system. When user select boarding city and destination city than out flight application check the entire airline available on this root and also check the availability of the ticket. After checking the availability of seats, web application display the airline option with the fare price of the ticket.

Download this project synopsis and final report from the end of this Project article.

When user books the ticket, he has to give passengers name and age and his phone number. He also has to give photo id details.

Use can cancel his booked ticket any time from the airline reservation system ticket cancellation screen.

This project is developed in PHP and MY SQL server.

You should choose PHP for dynamic and robust website. The reason of developing booking system project in PHP is given below.

PHP is easy to learn if we compare it to other web language. PHP is an open source web application language; it’s completely free of cost. That’s why small companies use it and it is easy to get job as PHP developer. It is easy to learn PHP syntax because those are logical and command functions describing exactly what they do.

Airline reservation web application development in PHP means developing a dynamic web pages using the server-side scripting language PHP language can be used to develop any type of website and can handle traffic load . PHP support most of the operating system so it is platform independent. IT supports all major databases including MySQL.
9. TESTING


Testing is a process, which reveals errors in the program. It is the major quality measure employed during software development. During testing, the program is executed with a set of conditions known as test cases and the output is evaluated to determine whether the program is performing as expected.


In order to make sure that the system does not have errors, the different levels of testing strategies that are applied at differing phases of software development are:


Levels of Testing:

























































Units Units Units














i/P integration o/p i/p integration o/P



Module1 module2 module3



System Testing: Presentation +business + database


UAT: user acceptance testing







Sponsored Links





9.1 TYPES OF TESTING:


Unit Testing


Unit Testing is done on individual modules as they are completed and become executable. It is confined only to the designer's requirements.


Each module can be tested using the following two strategies:


Black Box Testing of airline reservation system project developed in PHP and MY SQL.


In this strategy some test cases are generated as input conditions that fully execute all functional requirements for the program. This testing has been uses to find errors in the following categories:


a) Incorrect or missing functions


b) Interface errors


c) Errors in data structure or external database access


d) Performance errors


e) Initialization and termination errors.


In this testing only the output is checked for correctness. The logical flow of the data is not checked.

White Box testing of PHP Project - online airline reservation






In this the test cases are generated on the logic of each module by drawing flow graphs of that module and logical decisions are tested on all the cases.


It has been uses to generate the test cases in the following cases:


a) Guarantee that all independent paths have been executed.


b) Execute all logical decisions on their true and false sides.


c) Execute all loops at their boundaries and within their operational bounds.


d) Execute internal data structures to ensure their validity.


Integrating Testing


Integration testing ensures that software and subsystems work together as a whole in PHP and MY SQL server environment. It tests the interface of all the modules to make sure that the modules behave properly when integrated together.


System Testing


Involves in-house testing of the entire system before delivery to the user. Its aim is to satisfy the user the system meets all requirements of the client's specifications.


Acceptance Testing


It is a pre-delivery testing in which entire system is tested at client's site on real world data to find errors.

Validation of flight reservation system with PHP source code


The airline reservation system has been tested and implemented successfully and thus ensured that all the requirements as listed in the software requirements specification are completely fulfilled. In case of erroneous input corresponding error messages are displayed.










Compilation Test:


It was a good idea to do our stress testing early on, because it gave us time to fix some of the unexpected deadlocks and stability problems that only occurred when components were exposed to very high transaction volumes.






Execution Test:


This program was successfully loaded and executed. Because of good programming there was no execution error.
Output Test:


The successful output screens are placed in the output screens section above.

FLIGHT SCHEDULES screen is only accessible for admin. From this screen user can schedule airline time and also view the feedback of the users about the flight system. Admin can also check passengers list of any airline. Clicking on log out button close the session and log out the user from the admin panel.





Description: Updating, deleting of flight can be done through this form by admin.

PASSENGERS LIST

Admin can check passengers’ details from passengers list. Here passengers name, ticket id and airline name and number of passengers details are displayed.




Description: This is list of passengers travelling through different flights can be managed by admin through this form.FEEDBACK VIEW





Description: This form shows feedback from passengers to admin. From feedback page admin can check the complaint and feedback message of the users with their username, email address.




TIMINGS OF FLIGHTS





Description: This form gives timings of flights based on source and destination stations picked by user. Price and seats availability can also be viewed.




AIRLINE RESERVATION SYSTEM PROJECT IN ASP.NET





Overview of the Airline Flight Reservation System Project in Asp.Net with Source code.

Airline Reservation system Project is developed to book tickets online.

I have selected Airline reservation system to develop final year project because I have good knowledge of Airline like how it works, how flight tickets are booked and how to cancel them.

Sponsored Links








This project report can be used by BSc CS, IT, B tech IT, CS, Computer science and information technology students.

Below is the Home page of the Airline reservation system project developed in asp.net.




Figure 1 Online airline ticket reservation system project in asp.net - HOME PAGEFrom home page user can register to system on line from anywhere and can access airline reservation system. While registering to the system user have fill up mandatory information like name of the passenger, log in name. User can select gender on registration form and can give location and mobile number. After entering the mandatory information on airline registration form user have to click on Register button to complete the registration system and to become the active user of airline reservation system.

User can also navigate to travel news page. Travel news page update the user about travel destination and other precautions during the traveling by plane or flight. This page of the system also gives the guide about the most desirable tourist place. Travel news page is designed using C#.net and asp.Net.

Clicking on contact us link user goes to contact us page of the airline reservation system website. Here user can get the mobile number of customer care or administration mobile number and can send the email to airline administration. Here user can also send feedback about the airline reservation system services.


4.1.1 EXISTING SYSTEM:


Before online flight ticket booking system if any person wants to book a flight ticket, he use to follow one of these things:
He has to go to the Airport and book his ticket.
He has to fill up airline ticket reservation form manually and submit it at airport.
Fill the Ticket form on system and get the print out as paper documents to submit it at Airport.
Booking the Ticket at some particular registered ticket counters.


So in existing system user have to go airport to reserve his ticket. This process is very time consuming and because of this user has to face many problem in getting a ticket. If we online this process, we can make ticket reservation process very smooth and fast.


4.1.2 PROPOSED SYSTEM:


The Proposed reservation system ensures the complete freedom for users to book their ticket online. User at his own system can logon to airline ticket reservation website and can book his ticket. Our proposed system allows only registered users to book the tickets, view timings and cancel their tickets.

Ticket availability State Diagram




Figure 3 Airline reservation system project – ticket availability State Diagram


In this Proposal the entire work is done on online. After booking the ticket user can print his ticket. user can also send feedback and suggestion about airline ticket booking system to upgrade the system in future.





4.3 SYSTEM ARCHITECTURE


The online ticket booking application will follow three-tier architecture. In three-tier architecture application will run on three layer. User layer, application layer and data base layer. The client only displays the GUI and data but has no part in producing results.




Figure 2- Class Diagram of online Airline reservation system project in Asp.Net

Sponsored Links













7.6 DYNAMIC MODEL:


Sequence Diagrams:







Figure 4 Airline reservation system project – Sequence diagram


Collaboration Diagram:



In below diagram it is clearly describe that how admin interacts with system. this diagram describe that when admin log in to airline reservation system then system validate the account using MS SQL database server 2005 if admin username password is correct than system shows admin panel. Now user can update ticket price, schedule of flight and can cancel the ticket reserved online by the user. When admin do any changes in the admin panel than airline flight reservation system update the data base and return the result on admin panel of the airline reservation website. When admin clicks on log out button system close the session.


Collaboration Diagram:




Figure 5 Airline reservation system project – Collaboration Diagram When user log in to airline ticket booking system system ask for the credential for log in the system verify the credentials in the database. If the user credentials is valid system shows user panel. On user panel use can book ticket. for booking the ticket user have fill up airline reservation ticket form and submit the form online system check the availability of the ticket. if ticket is available system book the ticket and display the ticket booking confirmation message. User can print out his booked ticket.



5.2 Why I have used ASP.NET in developing airline flight reservation system project.


We have developed this project in asp.net because it is a part of the whole. NET framework. Asp.net is most important language at this time. So developing final year project in asp.net on airline project is a good idea. What you might not realize is that, unlike previous updates of ASP, it is more than an upgrade of existing technology but rather ASP.NET is the gateway to a whole new era of web development.


ASP.NET is a feature at web server releases


1. Microsoft IIS 5.0 on WINDOWS 2000 Server


2. Microsoft IIS 5.1 on WINDOWS XP






Some of the key goals of ASP.NET were to


1. Realize that bugs are a fact of life, as ASP.NET should be as fault tolerant as possible.


2. Make ASP.NET well factored, allowing customers to add in their own custom functionality, and extend/ replace built-in ASP.NET functionality.


3. Reduce the amount of code required to develop web applications.


4. Make ASP.NET a logical evolution of ASP, where existing ASP investment and therefore code can be reused with little, if any, change.


5. Remove the dependency on script engines, enabling pages to be type safe and compiled.










Benefits of ASP.NET - ASP.NET has several advantages over ASP.


The following are some of the benefits of ASP.NET:


1. Enable a new breed of web applications.


2. Improve deployment, scalability, and reliability.


3. Make code cleaner.


4. Provide better support for different browsers and devices.