Airline Flight information system

Airline Flight Information System

Introduction

This system consists of two parts: GUI front and oracle database server. The development environment of front is Oracle development2000 and write application programs in PL/SQL, using this tool we successfully designed the front and reports, make user-interface friendly.

System description

The airline flight information database consists of information relation to the operations of the airline industry. Each flight is identified by a flight number and consists of one or more flight legs with leg number 1,2, 3 etc. Each leg has many leg instances, one for each date on which the flight flies. Fares are kept for each flight, and sea reservations are kept for each leg instance. Information about airports and individual airplane type can land in which airport.

Real world object

The following is an outline for the application program to be developed for the airline reservation system; it includes a main menu of options and several sub-menus:

Main menu

This menu has four buttons: Customer Reports, Administrative and quit. Every button realized different functions.

Customer button: This button is used to invoke customer function menu, When user press this button, the system will appear customer function menu to let user operate some function.

Report: this button is used to invoke reporting function menu. When user press this button, the system will appear reporting function menu to produce some reports.

Administrative button: this button is used to invoke an administrative function menu. When user press this button, the system will appear administrative function menu to let DBA modify the database.

Quit button: When this button is pressed, it will quit the system

Customer Function Menu

This menu mainly realized all kinds of client operations. Including makes a reservation, cancel a reservation, confirm a reservation, print trip itinerary, locate fare and quit. These items locate at menu, when press the item, system will pop up corresponding window.

Makes a reservation: this item invokes a Make reservation windows let client make a reservation.

Cancel/confirm a reservation: this item invokes a trip itinerary report, produce a report about itinerary report, produce a report about itinerary and fare according the flight numbers the client input.

Quit: quit this submenu.

Reporting function menu

This menu provide the user the interface t0o get the different reports according to several search criteria such as airline, departure city, arrival city.

Print flight roster:

When this menu is invoked, user are wanted to input the flight number he (she) wants search.

Then the relative report is displayed according to that flight number and the date of the current

Day. The report includes two columns: flight number and custom name.

Print flight schedule:

This part display three kinds of reports:

Flight schedule of specific airline

According to the airline, which input by the user, the report output all the information about all

The flight that this airline open such as flight number, weekday, departure time, arrival time

And on tine or delay.

Flight schedule of specific departure city

According to the Departure City, which input by the user, the report output the information about

All the flight that this airline open such as flight number, weekday, departure time, arrival time

And on tine or delay.

Flight schedule of specific arrival city

According to the Arrival City which input vu the user, the report output all the information

About all the flight that this airline open such as flight number, weekday, departure

Time, arrival time and on time or delay.

Print flight performance report

According to the airline, which input by the user, the report list all the on time flight and all the

Delay flight, which is this airline separately.

Administration function menu

This menu enable the DBA of the system to make some change on the information database, suh as ass and drop a flight, create or update a leg instance, departure time and arrival time. This part includes three pages:

It is here that the system checks the user id and password of the DBA. By this way, the information system database ensures the access security.

Flight

After the DBS pass the access check of previous page, he (she) enters this page to modify the flight-related information: add and drop flight, update fares. Then he can use the button on this page to apply the operation on database: add, delete, update and quit. The DBA also can navigate all the records of flight schedule in the database by query, forward and backward button.

Schedule

This page enables the DBA to create and update the leg instance such as departure time and arrival time, then he can use the button on this page to apply the operation on the database: add, delete, update an quit. The DBA also can navigate all the records of flight schedule in the database by qyery, forward and backward button.

The feature of system

User-interface friendly

Can reserve every part flight

Provide very detail report

Have some exception handlers, system is robust

Have security mechanism to support system security

Client/server model is highly reliable, and clients access it transparently