A distributed airline database system stores the following information.

Flight details:

It includes the originating flight terminal and destination terminal, along with the stops in between, the number of seats booked/available seats between two destinations etc.

Customer description:

It includes customer code, name, address and phone number. This information may be used for keeping the records of the customer for any emergency or for any other kind of information.

Reservation description:

It includes customer details, code number, flight number, date of booking, date of travel.

PRODUCT FEATURES:

The major features of airline database system as shown in below entity–relationship model (ER model)