airline ticketing - synopsis
TRANSCRIPT
INTRODUCTION
Indian Airlines is one of the largest and busiest rail networks in the world, covering a route
length of over 62,000 km and transporting about millions of passengers and freight daily. The
Airlines meandering through the tunnels, the deserts, and mountain ranges traverse through the
length and breadth of the country, unfolding the landscapes and history of each state.
Airline reservation System is the application of planning organizing and control concepts to
critical-one-of a kind projects.The fundamental objective of a project work is to demonstrate how
tedious manual work using the computer capabilities can easily do. Airline Reservation System
helps user to get Airline ticket information online rather than manually. Specifically, it does the
following:-
1. Determines the user’s login and password.
2. Process to compile the computerized querying.
3. Process the module of Reservation.
4. Process the module of cancellation.
5. Process the module of PNR Status.
6. Process the all the queries as and when required.
7. Provides all printable forms and reports.
8. Keeps and maintains all the invoices and inventories.
NEED OF THE PROJECT
The Indian Airline is the worlds second largest Airline system. If going by figures it covers, 6853
stations and 63028 kilometers of track distance, carrying a load of 37840 passengers and around
500 tons of freight annually.
With this huge magnitude our Airline system faced a problem of a complete and fast reservation
system, which has been started as PRS (Passenger reservation system) in 1985 and was formed
around the objective of providing reserved reservation to the Flight travellers.
Due to the efforts put in this direction now reserved ticketing for anywhere in India is possible
through a network of booking terminals and Interactive Voice response systems on telephone, or
touch screens or passenger operated enquiry terminals.
Now one can easily plan the journey comfortably as the process is efficient and fast with being
easy to access. Reservations can be made through the Indian Airlines site or at the ample
reservation centers all over the country.
Also now there are authorized agencies which provide reservation facility on behalf of India
Airlines and without waiting in long line one can easily book a ticket. The booking is done
through an E-Ticket issue which have a PNR number of which one has to take a print and just
have to show at the station.It not only reservation but cancellation can also be done through this
system at ease and one can use a credit card to complete the process.
This being a big step in terms of improvement in the Airline system it is widely accepted across
the country.
OBJECTIVE
The objective is develop an automated system for the reservation of Airline which will keep
record of all related details about Airline.
The computerized reservation of Airline intends to provide better environment for customer.The
package aims to provide faster service and satisfied user as well as management of the Airlines.
REQUIREMENT ANALYSIS
HARDWARE REQUIRMENT:
Processor : Intel Pentium IV
: 2.4GHZ Or above
Clock speed : 500 MHZ
System bus : 32 bits
RAM : 256MB of RAM
HDD : 40 GB or higher
Monitor : SVGA COLOR
Keyboard : 108Keys
Mouse : 2 button mouse
SOFTWARE REQUIREMENTS :
OS : WINDOWS XP
Environment : Java Runtime Environment 1.5
Front end : Core Java J2SDK1.5
Back end : Microsoft Access 2007
DATA FLOW DIAGRAM
• DFDs are unambiguous and concise
• They can describe processing at physical as well as logical levels
• DFDs facilitate top-down development
• They permit outlining of preferences and scope
External Entity :
A producer or consumer of data
Examples: a person, a device, a sensor
Data must always originate somewhere
and must always be sent to something.
Process :
A data transformer (changes input
to output).
Data must always be processed in some
way to achieve system function.
DATA FLOW :
Data flows through a system, beginning
as input and be transformed into output.
DATA STORES :
Data is often stored for later use.
SYSTEM ANALYSIS:
System Analysis is a detailed study of the various operations performed by a system and
their relationships within and outside of the system. Here the key question is what all problems
exist in the present system? What must be done to solve the problem? Analysis begins when a
user or manager begins a study of the program using existing system.
EXISTING SYSTEM :
During analysis, data collected on the various files, decision points and transactions handled by
the present system. The commonly used tools in the system are Data Flow Diagram, interviews,
etc. Flighting, experience and common sense are required for collection of relevant information
needed to develop the system. The success of the system depends largely on how clearly the
problem is defined, thoroughly investigated and properly carried not only the mechanisms of
problem understanding but also the frame work of the solution. Thus it should be studied
thoroughly by collecting data about the system. Then the proposed system should be analyzed
thoroughly in accordance with the needs.
PROPOSED SYSTEM:
Proposed system is an “AIRLINE RESERVATION SYSTEM”. Our proposed system has the
following advantages.
User friendly Interface
Fast access to database
Less error
SYSTEM DESIGN:
INPUT FORM DESIGN :
Input Design is the process of converting user originated computer based format. Inaccurate
input data are the most common cause of errors in data processing .Errors entered by data entry
operators can be controlled by input design. The goal of designing input data is to make data
entry as easy, logical and free from errors as far as possible. In this system, the input screens are
developed according to the user requirements.
OUTPUT FORM DESIGN :
Computer output is the most important and direct source of information to the user. Efficient,
intelligible output design should improve the system relationship with the user and help in
decision-making. The outputs provide in the system are the softcopy report available for printing.
Printouts should be designed around the output requirement of the user. The output devices to
consider depend on the factor such as compatibility of the device with the system, response time
requirement and number of copies needed.
DATABASE DESIGN :
The general theme behind a database is to handle information as an integrated whole. A
database is a collection of interrelated data stored with minimum redundancy to serve many users
quickly and effectively. After designing the input and output, the analyst must concentrate on
database design or how data should be organized around user requirements. The general
objective is to make information access, easy quick, inexpensive and flexible for other users.
During database design the following objectives are concerned:-
Controlled Redundancy
Easy to learn and use
More information and low cost
Accuracy
Integrity
LEVEL 0 DFD :
DATA FLOW DIAGRAM :
Get User
Name and
Password
Login Table
User Details
Level 0 :
LEVEL 1 DFD :
LEVEL 2 :
LEVEL 2 :
Reservation
Gateway
Authentication
ProcessUser
Cancellatio
nReser
va-tion
PNR
Status Con
firmNo.
Wait
Train
No.
Date
Source/
Destination
PNRNo.
Date
ENTITY RELATIONSHIP DIAGRAM
Introduction :
The entity relationship diagram enables a software engineer to fully specify the data objects that
are input and output from a system, the attributes that define the properties of these objects, and
their relationships. Like most elements of the analysis model, the ERD is connected in an
iterative manner. The following approach is taken:
1. During requirements elicitation, customer are asked to list the “things” that the
application or business process addresses. These “things” evolve into a list of input and
output data objects as well as external entities that produce or consume information.
2. Taking the object one at a time, the analyst and customer define whether or not a
connection exists between the data object and other objects.
3. Wherever a connection exists, the analyst and the customer create one or more
object/relationship pair
4. For each object/relationship pair, cardinality and modality are explored.
5. Steps 2 through 4 are continued iteratively until all object/relationships have been
defined.
6. The attributes of each entity are defined.
7. An entity relationship diagram is formalized and reviewed.
8. Steps 1 through 7 are repeated until data modeling is complete.
PROCESS FLOW CHART :
It consists a single process, but it plays a very important role in studying the current system. This
gives just an overview of the proposed system.
AIRLINE
RESERVATION SYSTEM
PNR STATUS
Generate Ticket
RESERVATION
User Identity
Passenger Information
CANCELLATION
CHAPTER SCHEME1. Introduction
2. Overview
3. Need of the Project
4. Objective
5. Requirement Analysis
6. About JAVA
7. About Ms-Access
8. Modules
9. System Analysis
10. System Design
11. Data Flow Diagram
12. ER Diagram
13. Process Flowchart
14. Coding
15. Implementation
16. Maintenance
17. Future Enhancement
18. Conclusion
19. Bibliography