A

PROJECT REPORT ON
FLIGHT BOOKING MANAGEMENT SYSTEM
FOR
Pushkar Apartments, Shukrawar Peth, Pune
SUBMITTED BY:
MS.MUKTA GADGIL (TYBBA (CA), A, 15455)
MS.MRUNAL APTE (TYBBA (CA). A, 15419)
UNDER THE GUIDANCE OF:
PROF.PRIYANKA JAIN (CO-ORDINATOR)
PROF.PADMA NENE

SAVITIRIBAI PHULE PUNE UNIVERSITY

BACHELOR OF COMPUTER APPLICATION
GARWARE COLLEGE OF COMMERCE
 GARWARE COLLEGE OF COMMERCE

Karve Road, Deccan Gymkhana,

Pune-411004

CERTIFICATE
This is to certify that Ms. Mukta Gadgil and Ms. Mrunal Apte has successfully
completed the project entitled Flight Booking Management System

and has submitted the same to the satisfaction during the academic year 2017 -2018

Towards partial fulfillment of the degree Bachelor of Computer Application of

the Savitribai Phule Pune University

(Project Guide) (BCA In charge) (Principal)

(Internal Examiner) (External Examiner)

 CONTENTS

Company Profile

Project Profile

Study of the Existing System

-- Existing System

-- Problems with Existing system

-- Fact Finding Methods

Proposed System

-- Scope of the Proposed System

-- Objectives of the Proposed System

-- Feasibility Study

-- H/W and S/W Requirement

System Analysis

-- Context Level Diagram

-- Data Flow Diagram

-- Entity Relationship Diagram

System Design

-- Table Design

-- Form Design (With Input Values)

-- Report Design (With Data)

System Limitations

Future Enhancements
 Bibliography

Company Profile

Name of the Company : Eva Air Flight Booking Management System

Address of the Company : Pushkar Apartments, Shukrawar Peth, Pune

Services Provided :

1. Flight Details

2. Online Bookings

3. Cancellation of tickets.

Universal Booking & Services is a partnership firm which provides

online ticket booking services to its customers. It was established in 2010 and is
one of the pioneers in this field.

The management comprises of 2 partners which are Ms. Mukta Gadgil and
Ms. Mrunal Apte. It is an initiative of both Ms. Mukta Gadgil and Ms. Mrunal
Apte. Initially they started this activity on a small scale but now they are on the
verge of expanding their business. There are approximately 500 to 800 bookings
done per day. The online booking of tickets is done in a secure manner.

The process of booking a ticket is not complicated and any person having
minimal knowledge of internet can book a ticket. They also provide the live status
of flights. Both Ms. Mukta Gadgil and Ms. Mrunal Apte have taken a lot of effort
and put in hard work for bringing up Udaan Airline Bookings and Services.

Now they are interested in expanding in their business and providing their
services in a more efficient manner and to maintain a good relationship with their
customers.
 Project Profile
The online ticket booking infrastructure is designed to address the process. The
project aims at automating the ticket booking process which has the following
three modules :-

1. Registration Module

2. Administrative Module

3. Passenger Module

1.Registration Module :- In Registration Module first we ask passenger to give

his/her details. After registering with us, the passenger can log on to his/her
account and view all flight details such as timings, prices, availability of seats, date
and can book the ticket with unique ticket Id.

2.Administrative Module :- Administrative Module is provided for the sake of

administration to manage the system and update the content on a regular basis.
The major operations included in this module are:-

a) Create and maintain in airline schedules, fare, date, timings of flight.

b) View the passenger list.

c) View the available seats in the flight.

d) Cancel the tickets.

e) Updating the flight schedule, timings and fare.

3.Passenger Module :- This module is meant for passengers, where a user logging
into her/his account will view this panel. The major operations included in this
module are :-

a) View all airline schedules, timings, fare details and seat availability.

b) Book the tickets.

c) View and cancelling the ticket.

 Study of the Existing System

Study of the existing System and Requirement Specification

The Customers approach to the agency for the online air ticket reservation.
The advisor notes the sources, designation, number of tickets.
The advisor of agency advices customers about types of seats that can be of
following types:-

1) Domestic

In domestic, 100 seats are available and in international type minimum 250
seats and maximum 320 seats are there.
In Airline process three ways are there i.e.
1. One way source to destination
2. Round trip Source to designation to source (return back).
In the origin of form customer have to select code and city name.
In Departure column, customer have to enter their initial date if the trip is
round trip, enter return data too.
The airline system also requires no. of people for reservation.
Customers have to select between two classes is economy and business.
The system shows detailed information to the customers of available seats
of specific class.
In airline travelling passenger can chose direct travelling in which customer
will directly reach to the destination without any disturbance.
After that, customer has to enter his personal details and details of each
member present with them.
Insurance companies provide insurance offers if passengers want.
Customers get invoice based on expenditure.
The customers have to fill all the information for generating their code.
After ticket is booked. The message or e-mail will be sent to customer
contact.
After the ticket is booked, if the customer wants it cancelled then the ticket
cancelling charges will be applied and if it is from airline side, it will be
refundable.
 Existing System
Values:-
Travels arranges the stay of the passengers in star hotels and sightseeing
arranged by AC Coaches for customers comfort ability, they take care of
Passengers food (Indian) whenever possible they really try to fulfill all the
customers need. Shree travels assures that they provide the comfortable enjoy
and memorable journey to their each and every passenger.

Vision:-
Universal travels want to be most customer friendly travel company in
India. They provide Best Transfer facilities is their customers. They also arrange
group tours as per the location and duration. The customers satisfaction is the
main motive of the Shree Travels.

Problems with Existing System

Data maintenance requires a lot of files.
Paper work time is required.
Tremendous time is required.
Searching of any documents is very difficult.
Low Manpower to handle the data.
The need for backup.
Data Loss
Over load on the staff.
 Fact Finding Methods
i. Finding and recommendations:
A list of the major findings and recommendations of the study. It is ideal for
the user who requires quick access to the results of the analysis of the system
under study. Conclusion are stated, followed by list of the recommendation
and a just for them.

ii. Details of findings:

An outline if the methods and procedures under-take by the existing system,
followed by coverage of the objectives and procedures of the candidate
system. The ones included are also discussions of output reports, file
structure, and costs and benefits of the candidate system.
 Proposed System

Scope of the Proposed System

This project on Flight Booking System in the automation of registration process of
airline systems. The system is able to provide much information like passengers
information, criminals, list of all passengers etc.

The system also allows us to add records when a passenger reserves a ticket. It
enables to add any number of records in our database. But for intrinsic nature of
file handling, retrieval process is slow when we search a particular record in the
database because record is searched sequentially.

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 anywhere to any place.

Objectives of the Proposed System

1) Flight booking system is the process of checking and booking available
slots for airline.
2) The airline industry is no exemption. Flight Booking Management System
used to be standalone system. Each airline had its own system,
disconnected from other airline or ticket agents and usable only by a
designated number of airline employees.
3) To provide some amount of automation in airlines management.
4) To help airline system in making their business more efficient.
5) An added attraction for their potential customers.
 6) It will also show the attitude of the management that they are aware to the
newly introduced technology and ready to adopt them.

Feasibility Study
Once, the scopes defined and requirements are gathered, the software team and
others have worked to determine whether if it can be done within the dimensions
just noted. Software feasibility has four solid margins : (i) Finance, (ii) Time

(i) Finance :
The cost required will depend upon the hardware or software required for
developing the system and money which get spend on people working on that
system. The total cost will be in the form of human expenditure, hardware and
software expenditure. The cost can also increase if some change in the system is
demanded by the customer.

(ii) Time :
The team may have to spend a particular time slot for deciding what are
the requirements, central idea and overall structure of the system. Near about
one month will be required for organizing team, designing the system and some
more days for coding and testing the system. The team member should follow a
proper plan and take efforts so that, they dont have to face any risk in the middle
of developing the system or in future. There should also be proper understanding
among the team members.
 H/W and S/W Requirement
Hardware Requirement
Computer
Printer

Software Requirement
Visual Studio 6.0
Microsoft Word
Microsoft Access
 System Analysis
Context Level Diagram

Registration Passenger
Passenger
Master
Enter
Flight 0.0 Submit the
Route details
Flight Booking
Staff
Management Confirm
Record System
Passenger
Flight
details Staff Master
Booked

Manager Rules &

Regulations
 Data Flow Diagram

Passenger Details
Passenger Passenger
Details Master
Passenger 1.0
Master Flight
Enquiry Flight Master
Maintenance Details
Flight Schedule Details
Details
Schedule
Staff Schedule Master
Details
Database
Staff Master
 Second Level DFD

Passenger Details Given Passenger

Flight 2.0 (Schedule Master
Details displayed)
Enquiry
Search Routes
Routes Staff Master
Available
Staff
 Third Level DFD

Passenger Booking
Form Filling Details Passenger
(Registration) 3.0 Master
Registration
& Booking Display Flights
Management

Schedule Staff Master

Management
Show
Routes

Flight Master
 Fourth Level DFD

Ticket Receipt
Passenger Billing Done Passenger
Given
Master

Fare Paid 4.0

Staff Master
Print
Create Billing Receipt
Receipt
Choose Modes of
Staff Option Payment

Print Ticket
Ticket Master
 Fifth Level DFD

Passenger Request Passenger

Cancellation Refund
Master

Confirm 5.0
Confirmation
Refund
Cancellation
Confirm
Flight Master
Flight
Request
Validation Check
Cancellation
 Reports

Payment Master

Passenger
Master 6.0

Management
Flight Master Reports

Schedule
Master

Staff Master

Ticket Master
 ENTITY RELATIONSHIP DIAGRAM

has

has
1 M 1
1 Passenger has Staff
M M
1
Bill 1 1
makes
does has
has
has Booking M 1
1
1 Receipt
1
Flight
1 1 Ticket has
1
1
has
 System Design
Table Design
login master
Field Name Data Type Size Constraints Field
Description

username Text 30 Primary Key Username

password Number 20 Password

passenger master
Field Name Data Type Size Constraints Field
Description

pid Number 10 Primary Key Passenger ID

firstname Text 30 Passenger First

Name

lastname Text 30 Passenger Last

Name

dob Number 10 Date of Birth

padd Text 60 Passenger

Address

Nationality Text 30 Nationality

Contact No Number 10 Contact Number

Gender Text 6 Gender

flight master
Field Name Data Type Size Constraints Field Description

fid Number 20 Primary Key Flight ID

fdate Date 15 Date

ftype Text 30 Domestic/International

capacity Number 3 Capacity

route Text 30 Route

fname Text 20 Company Name

from Text 30 Flight origin

destination

to destination Text 30 Flight destination

staffmaster
Field Name Data Type Size Constraints Field
Description

eno Number 5 Primary Key Employee No

ename Text 30 Employee

Name
designation Text 20 Employee
designation
contactno Number 10 Contact
number
emailid Number, Text 30 E-mail ID

schedulemaster
Field Type Data Type Size Constraints Field Description

sno Number 8 Primary Key Schedule Number

fid Number 8 Foreign Key Flight Id

adt Date 8 Arrival Date

atime Number 4 Arrival Time

ddt Date 8 Departure Date

dtime Number 4 Departure Time

status Text 10 Status

ticketmaster
Field Name Data Type Size Constraints Field Description

tno Number 8 Primary Key Ticket Number

pid Number 8 Foreign Key Passenger Id

sno Number 8 Foreign Key Schedule Number

fid Number 8 Foreign Key Flight Id

tdt Date 8 Booking Date

class Text 10 Class

seatno Number 4 Seat Number

gate Number ,Text 15 Gate

food Text 20 Food

ticketpaymentmaster
Field Name Data Type Size Constraints Field Description

Tpno Number 8 Primary Key Ticket Payment

Number

Sno Number 8 Foreign Key Schedule Number

Tno Number 8 Foreign Key Ticket Number

Fare Number 10 Fare

Amt Number 10 Amount

Gst Number 3 Goods Service Tax

development Number 3 Devlopment Tax

tax

fuel tax Number 3 Fuel Surcharge

Netamt Number 10 Net Amount

Mop Text 8 Modes of Payment

bank name Text 20 Bank Name

crno/chqno Number 10 Credit Number/

Cheque Number
cancellationmaster
Field Name Data Type Size Constraints Field Description

cno Number 8 Primary Key Cancellation Number

tid Number 8 Foreign Key Ticket Id

pid Number 8 Foreign Key Passenger Id

fid Number 8 Foreign Key Flight Id

tamt Number 10 Total Amount

deduction Number 3 Deduction(%)

namt Number 10 Net Amount

cancellationreceiptmaster
Field Name Data Type Size Constraints Field Description

crpno Number 8 Primary Key Cancellation Receipt

Number

cno Number 8 Foreign Key Cancellation

Number

pid Number 8 Foreign Key Passenger Id

totamt Number 10 Total Amount

bankname Text 20 Bank Name

chqno Number 10 Cheque Number

LOGIN FORM
SPLASH FORM

MDI FORM
BOOKING ENQUIRY FORM
PASSENGER FORM
TICKET FORM
TICKETPAYMENT FORM
CANCELLATION FORM
 Data Reports
PASSENGER REPORT

FLIGHT REPORT
SCHEDULE REPORT

TICKET REPORT
TICKETPAYMENT REPORT
 System Limitations
Our Flight Booking Management System is very
efficient. But it has got some limitations.
Person handling this software must be familiar with
the computer environment.
To operate this system, the user must study the
software first, so that he/she can use it well.
 Future Enhancements

1. Future of this project is to replace the manual work of movie shop

management system with the new advanced computerized system.
User does not need much training to use this software as the
software is really user-friendly and easy to understand it replaces
all the paper work also. In this software we can store thousands of
records. Sometimes, the main advantages are :-

Customer numbers are generated automatically by the system

itself.

If any invalid entry is done by the users which is the nature of

human being but checks by the machine so the software gives
the error message to the users to indicate about the invalid
entry.

While transfer of any customer such as incoming customer, it

will update both the file and incoming customer so that if we
want to know number of incoming customer, it will be easy
for us.
 BIBLIOGRAPHY
Black Book
Yatra.com
Bookmytrip.com