Users of the system should be able to retrieve flight information between two given cities with the given date/time of travel from the database. A route from city A to city B is a sequence of connecting flights from A to B such that: a) there are at most two connecting stops, excluding the starting city and destination city of the trip, b) the connecting time is between one to two hours. The system will support two types of user privileges, Customer, and Employee. Customers will have access to customer functions, and the employees will have access to both customer and flight management functions. The customer should be able to do the following functions:

Make a new reservation

• One-way

• Round-Trip

• Multi-city

• Flexible Date/time

• Confirmation

Cancel an existing reservation

View his itinerary

The Employee should have following management functionalities:

CUSTOMER FUNCTIONS.

• Get all customers who have seats reserved on a given flight.

• Get all flights for a given airport.

• View flight schedule.

• Get all flights whose arrival and departure times are on time/delayed.

• Calculate total sales for a given flight.

ADMINISTRATIVE

• Add/Delete a flight

• Add a new airport

• Update fare for flights.

• Add a new flight leg instance.

• Update departure/arrival times for flight leg instances.

Each flight has a limited number of available seats. There are a number of flights which depart from or arrive at different cities on different dates and time.