Airline Reservation System
Salman Bin Abdulaziz Abdulaziz University College of Arts and Sciences Computer Science Department
Airline Reservation System Mohammad Saad - 428440620 Majed Abdullah - 428440629 Ayed Saad - 429441179
Supervisor: Mr. Loai Foad Alzoubi
1
Airline Reservation System
College of Arts and Sciences in Wadi AlDawaser Computer Science Department
Committee members discuss the project: 123-
Chairman of Depart : Dr. Saied Abd El-Atty. Signature:
2
Airline Reservation System ACKNOWLEDGEMENTS
We would like to take this opportunity to express my gratitude towards all the people who have in various ways, helped in the successful completion of my project. We express our sincere gratitude to Dr. Naser Al Mohaizee, Dean, College of Arts & Sciences, for providing us with excellent facilities that has helped us in the successful completion of the project. We are thankful to Dr. Saied Abd El-Atty., Department chairman, Dept of CS , College of Arts & Sciences, Wadi Ad Dawassir for his constant co-operation and support. We must convey our gratitude to Ms. Loai F Alzoubi who has helped us and guided me through the entire life cycle of the project. And giving us the constant source of inspiration and help in preparing the project, personally correcting my work and providing encouragement throughout the project. We would also like to specially thank our parents for their constant moral support and encouragement throughout the project. It is they who have helped achieve all my dreamsthrough their blessings throughout our life.
Abstract 3
Airline Reservation System The Airline Reservation System project is an implementation of a general Airline Ticketing website like Saudi airlines, which helps the customers to search the availability and prices of various airline tickets, along with the different packages available with the reservations. This project also covers various features like online registration of the users, modifying the details of the website by the management staff or administrator of the website, by adding, deleting or modifying the customer details, flights or packages information. In general, this website would be designed to perform like any other airline ticketing website available online. The objective of the project is to design an Airline Reservation System application which enables the customers to search and book flights, packages and hotels. The project has been designed in C#.NET technology and consists of a SQL server which acts as the database for the project. My motivation for the project came from my enthusiasm and strong urge to learn C# and .NET which is one of the fastest growing technologies in today’s world. The Airline Reservation System project mainly consists of two types of users. The customers who access the information provided by the website and the administrator who modifies and updates the information available in the website. All the data needed for the application is stored in the form of tables in the SQL server 2008. The report contains the details of all the tasks carried out during the entire software development life cycle of the Airline Reservation Project. This document depicts all the details of the project starting from the project design to testing.
4
Airline Reservation System Table of Content
Page No ACKNOWLEDGEMENTS
3
Abstract
4
List of figures
7
List of tables
7
Chapter One 1.1 Introduction
8
1.2Problem Statement
9
3-Project scope
9
4- Project Objectives
10
5- Project Schedule
11
6- Project Tools
11
Chapter Two 1- Related Work
12
Chapter Three 1-Requirement Analysis & Specification
15
2-Use case
17
3-Sequence Diagrams
18
4-Context Diagram
19
4-Data Flow Diagram
20
5-Activity Diagram
21
Chapter Four 1-Project Implementation
22
2-Database Design
23
3-User Interface
27
Chapter Five
5
Airline Reservation System Conclusion
38
References
41
6
Airline Reservation System LIST OF FIGURES
1- Figure 1: Use-Case Diagram
17
2- Figure 2: Sequence Diagram
18
3- Figure 3: Context Diagram
19
3- Figure 4: Data Flow Diagram
20
4 - Figure 5 : A c t i v i t y D i a g r a m
21
5-User Interface
27
7
Airline Reservation System LIST OF TABLES
1-Fatora
23
2-Medinfo
24
3-Sold
25
4-Login
25
5-Test
26
6-Pass
26
8
Airline Reservation System CHAPTER 1 PROJECT BACKGROUND
1.1
Introduction
The main purpose of this vision document is to list the requirements of the Airline Reservation System project. This document also helps us to collect and analyze the ideas gathered for the project. This vision document will be subject to change, if more requirements are added to the project. This document is mainly prepared to set stage for the design phase of the project. The document being prepared is the first version of vision document for the Airline Reservation System project. C#.NET is a new technology which is being used a lot in the IT field. My interest to learn this new technology has prompted me to take up this project, which would set the stage for the applications I would be developing in the future. The Airline Reservation System project is an implementation of a general Airline Ticketing website like Orbits, which helps the customers to search the availability and prices of various airline tickets, along with the different packages available with the reservations. This project also covers various features like online registration of the users, modifying the details of the website by the management staff or administrator of the website, by adding, deleting or modifying the customer details, flights or packages information. In general, this website would be designed to perform like any other airline ticketing website available online.
1.2 Problem Statement 9
Airline Reservation System The definition of our problem lies in manual system and a fully automated system. 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 unstructured. Automated 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. 1.3 Project Scope
The Airline Reservation System is a software application to assist an airline with transaction related to making ticket reservations, which includes blocking, .reserving, canceling and rescheduling tickets The system shows all possible combinations available for a pair of origin – destination cities. The system provides the user friendly environment to reserve .the tickets for flights. Also provide all information of the each flight 1.4 Project Objectives
A few factors that direct us to develop a new system are given below: 1) Faster System 2) Accuracy 3) Reliability 4) Informative 5) Reservations and cancellations from any where to any place
10
Airline Reservation System CHAPTER TWO RELATED WORK
Overview 2.1
An airline reservation system is part of the so-called passenger service systems (PSS), which are applications supporting the direct contact with the passenger . The airline reservations system (ARS) was one of the earliest changes to improve efficiency. ARS eventually evolved into the computer reservations system (CRS). A computer reservation system is used for the reservations of a particular airline and interfaces with a global distribution system (GDS) which supports travel agencies and other distribution channels in making reservations .for most major airlines in a single system 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 GDS. A second type of direct distribution channel is consumers who use the internet or mobile applications to make their own reservations. Travel agencies and other indirect distribution channels access the same GDS as those accessed by the airlines' reservation systems, and all messaging is transmitted by a standardized messaging system that functions on two types of messaging that transmit on Site's HLN [high level network]. These message types are called Type B [TTY] for remarks-like communications and Type A [EDIFACT] for secured information. Message construction standards are set by IATA and ICAO, are global, and apply to more than air transportation. Since airline reservation systems are business critical applications, and their functionally quite complex, .the operation of an in-house airline reservation system is relatively expensive
11
Airline Reservation System Prior to deregulation, airlines owned their own reservation systems with travel agents subscribing to them. Today, the GDS are run by independent companies .with airlines and travel agencies as major subscribers As of February 2009, there are only three major GDS providers in the market space :Amadeus, Travel port (the merged World span and Galileo systems), Saber and Shares. There is one major Regional GDS, Abacus, serving the Asian marketplace and a number of regional players serving single countries, including .(Travel sky (China), Infinite and Axes (both Japan) and Topes (South Korea Reservation systems like Novitiate hosts "ticket less" airlines such as Air Tran, and previously hosted Jet Blue. Virgin America is hosted by if lyres (airs), which is a new generation reservation system developed and operated by IBS . Software Service Pvt. Ltd. Virgin America has decided to move to Sabers now In additional to these "standardized" GDS, some airlines have proprietary versions which they use to run their flight operations. A few examples of this kind of system are Deltamatic (built off the World span platform) and EDS SHARES. SITA Reservations remains the largest neutral multi-host airline .reservations system, with over 100 airlines currently managing inventory :Inventory management 2.2
An airline’s inventory contains all flights with their available seats. The inventory of an airline is generally divided into service classes (e.g. first, business or economy class) and up to 26 booking classes, for which different prices and booking conditions apply. Inventory data is imported and maintained through a schedule distribution system over standardized interfaces. One of the core functions of the inventory management is the inventory control. Inventory control steers how many seats are available in the different booking classes, by opening and closing individual booking classes for sale. In combination with the fares and booking conditions stored in the Fare Quote System the price for each sold seat is determined. In most cases inventory control has a real time interface to an airline’s Yield management system to support a permanent optimization of
12
Airline Reservation System the offered booking classes in response to changes in demand or pricing .strategies of a competitor :Availability Display and Reservation 2.3
Users access an airline’s inventory through an availability display. It contains all offered flights for a particular city-pair with their available seats in the different booking classes. This display contains flights which are operated by the airline itself as well as code share flights which are operated in co-operation with another airline. If the city pair is not one on which the airline offers service it may display a connection using its own flights or display the flights of other airlines. The availability of seats of other airlines is updated through standard industry interfaces. Depending on the type of co-operation it supports access to the last seat (last seat availability) in real-time. Reservations for individual passengers or groups are stored in a so-called passenger name record (PNR ). Among other data, the PNR contains personal information such as name, contact information or special services requests (Sirs) e.g. for a vegetarian meal, as well as the flights (segments) and issued tickets. Some reservation systems also allow to store customer data in profiles to avoid data re-entry each time a new reservation is made for a known passenger. In addition most systems have interfaces to CRM systems or customer loyalty applications (akin frequent traveler systems). Before a flight departs the so-called passenger name list (PNL) is handed over to the departure control system that is used to check-in passengers and baggage. Reservation data such as the number of booked passengers and special service requests is also transferred to flight operations systems, crew management and catering systems. Once a flight has departed the reservation system is updated with a list of the checked-in passengers (e.g. passengers who had a reservation but did not check in (no shows) and passengers who checked in, but didn’t have a reservation (go shows)). Finally data needed for revenue accounting and reporting is handed over to .administrative systems
13
Airline Reservation System CHAPTER 3 SYSTEM REQUIRMENT AND ANALYSIS 3.1 Requirements Specification
The project is focused on fulfilling the following feature of Design and Implementation of Airline Reservation System Using c# language and Microsoft SQL Server 2008 Database. 3.2 Feasibility Study
Before proceeding to commit on a large expenditure, that is involved in the development of a new system, Basically, a feasibility study is done to find out whether the system that is proposed, will be acceptable (for use by the eventual users of the system), affordable (given the time and cost constraints of the organization) and possible (to built it with the given technology and resources). A. Economical Feasibility
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 20 Lacks P.A. Hence the new system is economically feasible. B. Technical Feasibility
The new system requires only 6 trained person to work with the system and in overall 10 people per office are sufficient. So we will identify 6 best people from existing system and train them. As our existing system is purely manual, so we need a one time investment of Rs 4 Lacks for the purchase of 7 computers, 5 Ticket printers, a laser printer, AC and networking etc. It requires 20 Lacks PA
14
Airline Reservation System as a operating cost. With the above details our system is technically feasible as after investing 24 lacks in a year, the company is still saving Rs 25 Lacks PA. C. Operational Feasibility
The new solution is feasible in all sence but operationally it is not. The new system demands the expulsion of at least 15 people from the company. It creates an environment of joblessness and fear among the employees. It can lead to an indefinite strike in the company also. So the management must take corrective actions prior in advance in order to start the further proceedings. 3.3 System Diagrams This was the most important phase of my project life cycle .It had connected my maximum time. •
Use-Case Diagram
Figure1: Use-case Diagram for Customer
15
Airline Reservation System
Figure 2: Use-Case Diagram for Administration •
Block diagram
The block diagram given bellow depicts various facts which were understood by one during the analysis phase.
Figure 3: Block diagram
16
Airline Reservation System •
Sequence Diagrams
The sequence diagram for the Pharmacy Management system is as follows:
Figure 4: Sequence diagram
4. System Requirements: 4.1 External Interface Requirements 4.1.1 -User Interfaces:
The user interface will consist of home page contain all functionality to the customer. This allows user to login or if new user there is a registration. In addition the user can easily find out the flight that they want. There is also information of the delayed or cancelled flights. It is very user friendly they can reserve tickets very easily.
17
Airline Reservation System 4.1.2-Hardware Interfaces:
The system has no hardware interface requirements. 4.1.3-Software Interfaces:
The software interface will consist of dealing with the required Software tools which are: •
ASP.Net under C# language.
•
Microsoft SQL Server 2008 Database.
•
Rational Rose Tool
•
Windows(98/ME/2000/XP/Vista/7) (Operating
System) 4.2 Functional Requirements •
User account:
The registered user can directly do the registration of flights and if there is a new user he may register or he only see the flight details. But for the reservation of ticket he must register first. •
Creation of new user account :
When there is a new customer he should fill the form containing field like Name, address, contact no. , gender, email id, age etc and also user_id and password. •
Checking Availability:
For to check the available flight the user should input the origin city and Destination city, date of journey.
18
Airline Reservation System
•
Reservation of Flight:
After providing all information the system will ask user for confirmation . After confirming the information the seats get reserved. •
Canceling / Rescheduling of Ticket :
To cancel the reservation the customer should provide the details about Ticket no and flight no 4.3 Other Nonfunctional Requirements: •
Performance Requirements:
Performance of the system is depend on the bandwidth of the internet. and also the hardware itself. •
Security Requirements:
The only authorized person can see the confidential Information. The information of the customer is only available for the administrator. •
Software Quality Attributes:
The system very user friendly, interoperable and flexible
19
Airline Reservation System
CHAPTER 4
SYSTEM DESIGN 4.1 Introduction
In this phase initially I had designed E-R diagram of the processes, in order to identify various entities and relationship set, entity set, attributers, link attributes The Diagram of this process as under. After this step we had tried design the data base for the new system and normalized it the tables motivated in data dictionaries enclosed as annex II is an out come of this step 4.2 System Diagrams •
Class Diagram:
Figure 5: Class diagram
20
Airline Reservation System
21
Airline Reservation System
•
Data Flow Diagram
In order to design a better solution, we had designed the DFD for system including all technical processing details is given bellow
Figure 6: Data Flow Diagram for System
22
Airline Reservation System
4.3 Database Design: •
ER-Diagram
Figure 11: E-R Diagram for Booking Department •
Database Schema
23
Airline Reservation System
Figure 11: E-R Diagram for Cancelation
24
Airline Reservation System
Data base Tables:
CHAPTER 5 PROJECT IMPLEMENTATION
APPENDECIES Appendix A: System Code
25
