Airline Reservations Systems

Airline Reservations Systems

In this kind of system, the items of data include:

1. Reservations by a single customer on a single flight, including such information as assigned seat or meal preference.

2. Information about flights the airports they fly from and to, their departure and arrival times, or the aircraft flown, for example.

3. Information about ticket prices, requirements, and availability.

Typical queries ask for flights leaving around a certain time from one given city to another, what seats are available, and at what prices. Typical data modifications include the booking of a flight for a customer, assigning a seat, or indicating a meal preference. Many agents will be accessing parts of the data at any given time. The DBMS must allow such simultaneous accesses, prevent problems such as two agents assigning the same seat  simultaneously, and protect against loss of records if the system suddenly fails.