It has number of branches, which are spread over the country or the world. The Airline Reservation System ARS provides an interface to schedule flights and reservations for an airline that services. Its 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. We had visited various person of the company.
|Published (Last):||17 July 2016|
|PDF File Size:||13.50 Mb|
|ePub File Size:||19.76 Mb|
|Price:||Free* [*Free Regsitration Required]|
It has number of branches, which are spread over the country or the world. The Airline Reservation System ARS provides an interface to schedule flights and reservations for an airline that services.
Its 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. We had visited various person of the company. The existing system was studied by means of Interviews Record Reviews Interviews: User interviews were conducted to retrieve the qualitative information.
These interviews, which were unstructured, provided opportunity to gather information from the respondents who involved in the process for a long time. This study covered. Hardware Configuration:- For the successful run of the proposed system the required stand alone Personal Computer with, minimum hardware required to run the system is as below. Visual Basic 6. Features of ORACLE : - It is a high performance, full tolerant relational database management System especially designed for large database application.
These queries are simple English constructs that allow adhoc data manipulation from a table. Grant and revoke limits access to information down to row and column level. Views are valuable features for limiting access to the primary tackles in the database. Built-in query language is designed in the RDBMS, so that it can manipulate sets of data one or more tuples.
Using any of the other methods, you have not only to specify what need to be done but how it has to be done as well.
It also allows creating robust applications that fully make use of the graphical user interface. This is known as Event driven programming language. 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.
In the same way Ticket cancellation is followed. If Fare is increased or decreased then changes into Fare Book. The current context is related to maintain the ticket Reservation-Cancel ticket. The important reason is to make-work easy. No need to search a Flight register for entry or any other transaction. Computerization of this must fulfilled the requirements of working staff due to effective work of computer in terms of efficiency, speed, accuracy, storage capacity and quickness.
Even though it is costly, it is recommended the computerization of the ticket issue process. A Data Flow Diagram DFD is a graphical technique that depicts information flow and the transformations that are applied as data move from input to output. The data flow diagram is know as a data flow graph or a bubble chart.
The Data Flow Diagram may be used to representation a system or software at any level of abstraction. In fact, DFDs may be used partitioned into levels that represent increasing information flow and functional detail. Therefore, the DFD provides a mechanism for functional modeling as information flow modeling.
The Data Flow Diagram DFD serves two purposes: 1 To provide an indication of how data are transformed as they move through the system and 2 To depict the functions that transform the data flow.
The DFD provides additional information that is used during the analysis of the information domain and serves as a basis for the modeling of function. Additional processes and information flow paths are represented as the level 0 is partitioned to reveal details. Each of the proves represents at level 1 is sub function of the overall system depicted in the context model.
Each of the process may be refined are layered to depict more detail. Information continuity must be maintained in every layer, that is input and output to each refinement must remain the same.
The dictionary defines the name, description, source of data, users of data, and keywords in data, formula to derive the data, specification and such other details. Data dictionary brings common understanding of the data in the organization. RDBMS provides software to create the dictionary. Data Dictionaries are an integral component of structured analysis, since data flow diagram by them do not fully describe the information about the system.
The data dictionary provides additional information about the system. A data dictionary is a catalogue — a repository — of the elements in a system. These elements center on data the way they are structured to meet user requirements and organization needs.
In a data dictionary, a list of all the elements composing the data flowing through a system is included. If a project team member wants to know the definition of a data item name or the contents of a particular data flow, the information will be available in the data dictionary. Descriptions of all data used in the system are given in a data dictionary. When the user starts the application from the program group, then splash screen is displayed.
The login screen is used for authentication purpose. The login screen asks the user to enter the username and password. When the system is installed then after the splash screen, in the login screen the user must be created first. The admin user only creates another user.
In my 37 system username and password must be 15 character. To enter in the system first user has to enter with following user name and password. From here the user can perform desire operations. Actually it is a menu-based screen so user can perform operations by selecting then from the menu or submenu.
By selecting the desired option the associated form will be shown. The transaction menu contains options like Reservation and Cancellation of tickets. By selecting the desired option the associated report will be shown. Only admin user can create new user. In this form enter username and password with confirmation password.
To change password username of the user will be entered. Enter the username of the user which you want to delete. Only admin user can delete the user. This form is used to show the information of branch, selecting for reserve ticket.
This form is used to select any extra other services of the system. At a time only one service is used to reserve the ticket. This form is used to shows the capacity of first class, business class , economic class and also the waiting list capacity of the first class, business class and economic class.
When you press on save button after adding a record a fare information form will be opened to add fare information. In which route code is to be select and through route code fare can be shown. To add fare information in first class fare, business class fare and economic class fare information. This form automatically operate after reserving the ticket.
If the ticket is confirmed then the record will be insert into the flight information, but whether the ticket is not confirmed then the record will not inserted into the flight information form. If two ticket is confirmed with same flight no and flight date and class then it will increment by 1 in booking seats. This form is used to show the flight information. This form used for the flight no and the name of the airbus.
It is also used to show the departure time and journey hours of the flight. And it will also shows that in week in which day the flight is gone. Using the route code it will shows the departure time, journey hours flight day1 and flight day2 of that flight.
In which Air tax, bag limit and cancellation deduction will be displayed. Air tax will be directly calculate in reservation form. And cancellation deduction within 12, 6 and 3 days will directly calculate when you cancel the ticket and cancellation amount will be calculated.
Air tax will be Rs. In this form route code, route description, origin and destination will be displayed. It shows with the whole information of the flight schedule information form. This form shows the reservation information. PNR number is auto generate number. In this form ticket fare which will comes from the fare table. In total fare ticket fare, air tax and service fare will be calculated automatically. And if you press on save button and press yes then ticket is cancelled.
In cancel amount field direct cancel amount will be calculated. The system has been developed in a way to make it very user friendly. It provides an on-line message and an error detection and error messages every time the user needs.
Any person having a little bit of window based can run this system without any pain. Almost all the difficulties of manual reservation have been removed by this system. Ti wind up let me welcome all the suggestions and other improvements, which the system needs so that it covers all the needs if the user in the user way. Parthasarathy - B. Khalakar 60 Related Papers.
Airlines Reservation System Class Diagram
All of the below diagrams has been used for the visualization of data processing and structured design of the Airlines process and working flow. It also identifies internal data stores of Airlines Employee, Airlines Company, Booking, Customer, Airlines Route that must be present in order for the Airlines system to do its job, and shows the flow of data between the various parts of Airlines Ticket, Airlines Route, Airlines Company, Airlines Employee, Booking of the system. You will highlight the main functionalities of Airlines. It may require more functionalities of Airlines to reach the necessary level of detail about the Airlines functioning. Net and MySQL. We are providing any types asp projects for students with source code, database, and documentation. We provide full asp.
ER Diagram for Online Hotel Reservation System ( Entity Relationship Diagram)
Airlines Reservation System Dataflow Diagram