Airline reservation system, Thesis of Computer Science

Download Airline reservation system and more Thesis Computer Science in PDF only on Docsity!

PROBLEM DEFINITION

The OVERSEAS TRAVELS company is one of the Airline Reservation Company in India. It has number of branches, which are spread over the country or the world. So person wants to reservation his/her ticket the he/she has to contact at nearest Overseas Travels branch. The Airline Reservation System (ARS) provides an interface to schedule flights and reservations for an airline that services. It is responsibility is to keep track of system users, customers, Airbus information, flight information and cancellation. The functionality of the ARS is broken into various primary groups. Customer reservation information and user were added, deleted and updated in the implementation phase to account for the way we decide to implement security. User keeps track of the username, password information and customer reservation information link provides a link between the customers reservation information and user table.

INTRODUCTION TO EXISTING SYSTEM

The Company follows a manual system for maintaining the Airline Reservation system. Whenever any requisition comes to the Counter to issue a ticket the firstly the Ticket Capacity checked whether the required quantity of the ticket is present or not. If the required tickets is present then issue a ticket and update the reservation information and an entry is done to the Ticket Issue Register. The day-to-day entries are made manually into the book that has gotten all the relevant entries. Check the Ticket Quantity regularly whether any ticket is not in, if so then Ticket Issue process is cancelled. In the same way Ticket cancellation is followed. If Fare is increased or decreased then changes into Fare Book. If New Flight is introduced then entry on relevant book, that process applies to Flight-Schedule, Airbus, and Branch. At the end of the year or when an intermediate report is needed then prepare the report is required.

LIMITATIONS OF EXISTING SYSTEM

The Existing system includes problems like lack of time consuming, accuracy, high cost, security problems, etc. There are many problems in existing systems like:  (^) Manpower  (^) High cost  (^) Time and speed  (^) Security  (^) Complexity  (^) Maintenance  (^) Accuracy  (^) Storing  (^) Records might get lost or be insufficient due to manual errors.  (^) Maintaining and managing data is very costly and time consuming, because there are many documents that have to be maintained by each branch and copies have to be transferred to relative branches.  (^) Transfer of information within the branches is costly and time consuming.

OBJECTIVES OF PROPOSED SYSTEM

 Manual work has to be reduced.  Results to be receive quickly.  Get accuracy.  It uses concept of user friendliness.  It provides using of multiple applications at a time.  Increase security, speed, storing and accuracy.  Customer services can not only be satisfied but also enhanced to the extent that one can obtain or cancel a reservation from any branch for any given time.  To speed up the operation.  Managing and maintaining data becomes easier.  Provide convenience to travelers.

ADVANTAGES OF PROPOSED SYSTEM

o (^) The proposed system due to computerized is much faster in reservation process, cancellation process and transactions. o (^) Transfer of information from various branches would become easier and faster. o (^) Managing and maintaining data becomes easier and cost effective due to very high amount and reliability of storage space available in the proposed system. o (^) Customer services can not only be satisfied but also enhanced to the extent that one can obtain or cancel a reservation from any given time.

REQUIREMENT ANALYSIS

As we have decided to develop a new system now it is time to determine the new requirements for the new system. As the user is the most important part of any system it is required to find the users requirements to develop a user-friendly system rather than having to develop a developer friendly system. The outputs required by the user that must be included into the proposed system are as follows:

1. The work for the particular user must be personalized.
2. Passport and valid visa are required for ticket booking. n (^) Tickets are print as in required order. n (^) The user must be provided easy if he wants to switch from one application to other at a time.

RESERVATION FORM

This form is used to reserve ticket. This form shows the reservation information. PNR number is auto generate number. In this form ticket fare which will comes from the fare table. And when you select class it’s fare will insert into ticket fare. And for flight no press “F1” key for flight list and service code. In total fare ticket fare, air tax and service fare will be calculated automatically. passenger information will be inserted and in passenger status if the status is confirm then the information of flight will be added in to flight information table, otherwise status is waiting then information will not be added into information table. In this form ADD, DELETE, EDIT, SAVE, CANCEL, FIRST, NEXT, PREVIOUS, LAST, FIND, PRINT, and EXIT following operation will be performed.

CANCELLATION FORM

This form is used to cancel the reserved ticket. When you press on add button small box is displayed like “Enter PNR number: - “ and enter the pnr number from the reservation form. And if you press on save button and press yes then ticket is cancelled. In find button you enter pnr number of reserved ticket it display the message like “NO SUCH PNR”. In cancel amount field direct cancel amount will be calculated.

CANCELLATION REPORT

This report shows the cancellation report from the cancel ticket.

THANK YOU !!!