17-08-2012, 11:31 AM
Air Lines Ticket Reservation
Air_Lines Ticket_Reservation Documentation.docx (Size: 387.33 KB / Downloads: 49)
CASE STUDY
Airlines have become one of the major sources of travel around the world. Today, passengers can choose from a wide variety of airline offering different prices and flight timings. With ever increasing number of passengers. It becomes quite difficult for an Airline company to manage the details of each passenger on a daily basis. Various tasks need to be undertaken to manage the reservations of passengers. For example, reservation executives, who manage the details of the reservation, have to undertake various steps such as:
• Checking the availability of seats on the particular date and time
• Storing the details of each passenger reserving a seat
• Updating the seat availability each time a seat is reserved or cancelled
These tasks, when performed manually, can create lots of problems such as repeating the records entered or not updating the available seats after reservation or cancellation. In addition, the records are not always secure from unauthorized access.
SDLC of Airline Ticket Reservation System
A software development follows a life cycle, which is termed as Software Development Life Cycle (SDLC). SDLC generally entails the following phases:
• Requirement analysis
• Software design
• Development
• Testing
• Implementation and maintenance
The Requirement Analysis Phase
The Airline Ticket Reservation System project will help an Airline company in making transactions such as managing reservations and cancellations and scheduling flights. The following requirements should be kept in mind while developing this project.
• The System should be protected from unauthenticated users
• The administrator must be able to add, update, and delete the details of flights and sectors in the database
• The administrator must able to manage the flight schedules
• The administrator must be able to view the detailed list of passengers, including the revenue generated by the Airline company on a daily basis
• The reservation of the passengers can be made before 30 days from of the flight
• If seats for a specific date and time are not available, passengers’ requests for reservation on these dates and time would be accommodated in waiting list
Login Module
The Login module is important from the security aspect of the Airline Ticket Reservation System. This module ensures that the system is protected against any unauthorized access. Only administrators and reservation executives are authorized to log on to this module with the login IDs and passwords assigned to them. The administrator has full control over the Airline Ticket Reservation System where as the reservation executives can only reserve and cancel the reservation. The administrators and reservation executives may also change their passwords if they wish to.
Admin Module
An administrator can log on, add, edit or delete the details of flights, sectors, and schedule of the flight in the Admin module. This module also allows administrators and reservation executives to view reports of the confirmed, overbooked, or wait listed passengers and sales generated on a daily basis. The can administrator also add new login id and update or delete the existing login id.
Reservation Module
The reservation Module provides the user interface for reserving and cancelling air tickets. In this module, reservation executives can reserve a seat of a particular class for a passenger after accepting all the required passenger information. After reservation the passenger needs to pay for the reservations according to the fares charged by the airline company. In addition, the reservation executives can cancel the reservations by entering valid PNR numbers of tickets generated at the time of reservation.
Designing the Back-end Database
The database of this project acts as the back end to store information such as flight details and passenger details. Here we have used Microsoft SQL Server 2005 as the database for the Airline Ticket Reservation System named as Ticket_Reservation database stores information such as passengers information, flight details, and schedule of flights in different tables.
Why choose MS-SQL Server 2005
Ms-SQL is a powerful multi-user RDBMS developed by Microsoft Corp. Data in access is organized in the form of tables. Within a table, records are arranged according to a common reference value, known as a primary key or the key field. The value in the key field is different for every record & thus helps in uniquely identifying records. A combination is called a composite key. Database of SQL have a default extension of .sql.
SQL also maintains index files for tables. An index is an internal table of values that access maintains to store the order of records. Index objects thus efficient access to data.
Design Methodologies
INPUT DESIGN
It is a process of converting user-oriented inputs to a computer-based format. In the system design phase, the expended data flow diagram identifies logical data flow, data stores, sources and destinations. A system flowchart specifies master files (data base) transaction files and computer programs. Input data are collected and organized into groups of similar data. Once identify, appropriate input medium (Screen design) are selected for processing. Inaccurate input data are the most common cause of errors in data processing. Errors entered by data entry operators can be control by input design (screen design).
OUTPUT DESIGN
Computer output is the most important and direct source of information to the user’s efficiency, intelligible (well structured). Output design should improve the system’s relationship with the user and help indecision-making. A major form of output is a hard copy from the printer (reports) printout should be designed around the output requirements of the users. The output devices to consider depends on factors such as compatibility of device, with the system, response time requirements, expected print quality and number of copies needed.