Synopsis

Of

Airline Reservation System

By
Name: Sana Faridi
Enrolment No: 105018980
Course code: CS-76

Submitted to the School of Computer and Information Sciences

In partial fulfillment of the requirements
For the degree of
Bachelor of Computer Applications
Indira Gandhi National Open University
Maidan Garhi

Student Declaration

I hereby declare that the project proposal titled Airline Reservation

System is submitted by me to the Indira Gandhi National Open University
regional Center, Aligarh for the partial fulfillment of the Degree of Bachelor
of Computer Applications. It is also declared that this project synopsis is not
submitted to any other Organization or University or College and is the
outcome of my own work.

Name of student: Sana Faridi

Enrolment No:

105018980

INDEX

S. No.

Topic

Title of the Project

Introduction

3.

Objective of the Project

4.

System Analysis

5.

Software Requirement

6.

Hardware Requirement

7.

Data Flow Diagram

8.

ER Diagram

Modules Description

10

Database Structure

11

Conclusion

12.

Future Scope

TITLE OF PROJECT

AIRLINE RESERVATION SYSTEM

Introduction
This Project aims to model the working of an Airline Reservation System. This Project
uses Java as the programming Language.
The Airline reservation system, as the name goes provides services to the travelers. It
reserves seats for its customers, maintains information and also updates the database.
This project is based on the 2-tier architecture. The Project is developed keeping in mind
the security needs of today. The project is totally built at administrative end and thus only
the administrator is guaranteed the access.
The purpose of the Airline Reservation System Project is to build an application program,
which an airline could use to manage the reservation of airline tickets. Passengers make
flight reservations through the ticketing staff of the airline, which can access a centralized
system to check on flight details. The system able to create flights, delete flights and
reserve seats for passengers according to their requested Destination, day and time.

Objective

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.

Project Category
Desktop GUI Application

Tools and Platform

1.
2.
3.
4.

Language
RDBMS/Backend
Query Language
Development Environment

:
:
:
:

Java
Oracle 10G
SQL
NetBeans 7.0

Hardware and Software Requirements

HARDWARE CONFIGURATION
1.
2.
3.
4.
5.
6.

Processor
RAM
HDD
Monitor
Pointing device
Keyboard

Pentium IV with 3.0 GHz.

512MB
40GB
15 Color monitor with 16 million colors
Two - button Mouse or 3-button Mouse.
104 Keys

SOFTWARE CONFIGURATION
1.
2.
3.

FRONT END
Platform
Back End

Net beans (Java)

Microsoft Windows
Oracle 10G

System Analysis
EXISTING SYSTEM:
The effectiveness of the system depends on the way in which the data is organized
.In the existing system, much of the data is entered manually and it can be very time
consuming. When records are accessed frequently, managing such records becomes
difficult. Therefore organizing data becomes difficult. The major limitations are:

Modifications are complicated

Much time consuming

Error prone

Unauthorized access of data

PROPOSED SYSTEM:
The proposed system is better and more efficient than existing System by keeping
in mind all the drawbacks of the present system to provide a permanent to them.
The primary aim of the new system is to speed up the transactions. User
friendliness is another peculiarity of the proposed system. Messages are displayed in
message boxes to make the system user friendly. The main Advantage of the proposed
system is the reduction in labor as it will be possible so search the details of various
places. Every record is checked for completeness and accuracy and then it is entered into
the database. The comments and valid messages are provided to get away redundant data.
Another important feature of the proposed system is the data security provided by the
system. The main objectives of the proposed system are:

Complex functions are done automatically

Processing time can be minimized

Simple and easy to manage

Chances of errors reduced

Faster and more accurate than the existing system

Easy for handling reports

The proposed system is complete software for Airline Reservation System, Which is
more efficient, reliable, faster and accurate for processing.

Feasibility Study
Feasibility study is the detailed study expanded from the result of initial investigation.
This is done by investigating the existing system in the area under investigation or
generally ideas about a new system. It is the test of a system proposal according to its
work ability, impact on organization, ability to meet user needs and effective use of
resources. Objective of feasibility study is to acquire a sense of the scope of the problem.
It is carried out to select the best system that meets performance requirements.
Feasibility analysis involves the following steps:
Form a project and appoint a project leader
Prepare system flowcharts
Weigh system performance
Prepare and report final project directive to management
There are three key considerations involved in feasibility analysis namely:
Economic feasibility
Technical feasibility
Operational feasibility
Economic Feasibility:
Economic feasibility is used to determine the benefits and savings expected from the
candidate system and to compare them with costs incurred. If benefits outweigh cost,
then decision will be to design and implement system. Otherwise, alterations will have to
be made to the proposed system. The proposed system is economically feasible.
Technical Feasibility:
Technical feasibility centers on existing system and to what extent it can support
proposed modifications. It involves financial enhancement. This evaluation determines
whether the technology needed for the proposed system is available or not. This is
concerned with specifying satisfy the user requirements. The technical needs of the
system may include front-end and backend-selection.

An important issue for the development of a project is the selection of suitable front-end
and back-end. Based on some aspects, we select the most suitable platform that suits the
needs of the organization.
Operational Feasibility:
The present system is easily understandable. The users are presented with friendly user
interface that helps them to understand the flow of the system more easily. Maximum
transparency has been provided. The new system is very much user friendly and
operational cost is bearable. The maintenance and working of the new system needs less
human efforts. The proposed project is beneficial to the organizational and is user
friendly.

Data Flow Diagram

Context Diagram

Ticket
Booking

Passenger

Ticket
Cancellation

Airline
Reservatio
n System

Flight Details

Administrator
Booking
Details

DFD for Booking Ticket

DFD For Cancel Ticket

DFD FOR FLIGHT ENQUIRY

FLIGHT

Flight Code For

Searching

Invalid Flight

Search Process

Flight

Accessing Flight
Info

Valid Flight For

Display

Display Process
Flight Info

Accessing Flight Info

DFD FOR TICKET ENQUIRY

TICKET
Ticket Code For
Searching

Invalid
Ticket

Search Process

Ticket

Accessing Ticket
Info

Valid Ticket For

Display

Display Process
Ticket Info

Accessing Ticket Info

DFD FOR CHANGE PASSWORD

USER

User Enter Their Id And

Password For Changing
Password

User_Id

Accessing User Info

Invalid Password

User_Id And
Password
Validity Process

Valid User For New

Password

New Password
Information

Password
Updation
Process

Updating Password

DFD FOR USER LOGIN

USER
User Enter Their Password & User_id for
opening the application
1

Password
Validity
Process

Accessing User Information

Invalid User Matched

Valid User For Software Access

ARS

USER_ID

ER Diagram

DATABASE DESIGN
TABLES
1. Cancellation.
This table is used to store the cancel details.
Field name
cancelid
reservationid

Description
Cancellation id
Reservation id

cancelationdate Date of Cancellation

refundmoney
Money to be

Data type
int
int
date
decimal

Size
10
10

Constraints
PRIMARY KEY
FOREIGN KEY

10,0

NOT NULL
NOT NULL

refundable

2. Classes
This table is used to store the class details.
Field name
Description
Classid
Id of the class
flightcode
classcode
classname
Name of the class
Fare
totalclassseat Total seats in a class

Data type
int
int
varchar
varchar
decimal
int

Size
10
10
50
50
10,0
10

constraints
PRIMARY KEY
FOREIGN KEY
NOT NULL
NOT NULL
NOT NULL
NOT NULL

3. Flight days
This table is used to store the flight days details
Field

Description

name
flightcode Code of the flight
Date
date
departure Departure time

Data type

Size

constraints

int
date
time

10

FOREIGN KEY
NOT NULL
NOT NULL

4. Flight details
This table is used to store the flight details.

Field name
flightcode
airlinecode
flightname
source

Description
Code of the flight
Code of the airlines
Name of the flight
Starting place of the

Data type
int
varchar
varchar
varchar

Size
10
100
100
100

constraints
PRIMARY KEY
NOT NULL
NOT NULL
NOT NULL

destination

flight
Destination of the

varchar

100

NOT NULL

int

10

NOT NULL

flight
totalcapacity Total capacity of the
flight

5. Login
This table is used to store the login details
Field

Description

name
username Name of the user
password Password for the user

Data type

Size

constraints

varchar
varchar

50
50

PRIMARY KEY
NOT NULL

Data type

Size

constraints

int
varchar
varchar

10
250
250

PRIMARY KEY
FOREIGN KEY
FOREIGN KEY

varchar
text

250

NOT NULL
NOT NULL

login
6. Mail
This table is used to store the mail details
Field

Description

name
mailid
Users mail id
Touser
Destination of the mail
fromuser By whom the mail is
Subject
message

sent
Subject of the mail
Message to be sent

7. Passenger
This table is used to store passenger details.
Field name
passengerno

Description
Number of the

passenger
flightcode
Code of the flight
Dob
Date of birth
address
nationality
Name
Name of the user
Gender
phoneno
Phone number
emailid
Mail id
passportno
Passport number
reservationid Reservation id

Data type
Int

Size
10

constraints
PRIMARY KEY

Int
Date
varchar
varchar
varchar
varchar
varchar
varchar
Int
Int

10

FOREIGN KEY
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
FOREIGN KEY

250
250
250
250
250
250
10
10

9. Payment
This table is used to store payment details

Field name Description

paymentid
creditcardno
paidamount
paymentdate
passengerno
-

Data type
Int
Int
decimal
date
Int

10. Reservation
This table is used to store reservation details.

Size
10
10
10,0
10

constraints
PRIMARY KEY
NULL
NOT NULL
NOT NULL
NOT NULL

Field name Description

reservationid
flightcode
journeydate
Source
Starting place of the

Data type
Int
Int
Date
varchar

Size
10
10
50

constraints
PRIMARY KEY
FOREIGN KEY
NOT NULL
NOT NULL

50

NOT NULL

destination

flight
Ending position of the

varchar

journeytime

flight
Time the flight starts

time

NOT NULL

MODULES
There are 5 modules in this project.

Administrator Module.

Reservation Module.

Search Module.

Payment.

Cancellation.

Administrator Module.
Enables the administrator to perform all administrative functions and manage

inventory over LAN. The administrator can define or modify routes, fares schedules
and assign or deny access for authorized users.

Reservation Module.

This module is used for booking the ticket.

Search Module.

This module is used to search the Flights on the basis of source, destination and
routes.

Payment.

It Provides the airline system with the ability to set up various payment options for
reservations.

Cancellation.

This module is used to cancel the existing booking.

Conclusion
The proposed system maintains the details of the passengers required by the reservation
system. This proposed system will keep the track of the required information for the
passengers account in the system. Thus, it helps user in efficient searching of
information.
The various benefits that can be realized from this project are:

Easy maintenance of information.

No dependency on a specific person to get required information.

Saves time and effort.

Eases task of auditing.

Scope for Future Enhancement

This Project can be made online so that user can book and cancel his ticket online from
anywhere.