Consider an Airline company named AeroLion* in its mission to streamline the reservation procedure to supply a reliable, user-friendly, and efficient reservation system. They appointed you as an analyst programmer to develop an Internet based flight booking system for their company.

This section describes the broad scope of AeroLion’s reservation system. You may need to refine it further and re-specify the requirements based on discussion. You may add features or simplify/make assumptions on some of the features/functionality. It is important not to over-simplify and at the same time it is equally important to keep the complexities within reach since this is a coursework project with limited time duration. You would strategise based on their strengths and weakness to provide a clear and detailed specification as intermediate report and then proceed on to build they system.

The system consists of delivering a rich client server-based reservation system that would be used by the reservation staff of AeroLion and would open flight seat reservations to customers through internet.

The system is envisaged to contain the following features:

Ø Logon features

Ø Maintenance of user logon and password

Ø Maintenance of customer details

Ø Maintenance of flight schedule

Ø Assume the flight consists of 150 seats, with 6 seats per row. There is no further categorization of the seats (i.e. there is no business or economy class for the seats) ØBooking and cancellation of flights

§ Booking of flights allows indication of meal preference

§ Assume there is the airline only fly to 3 destinations – oSingapore – Kuala Lumpur – Singapore o Singapore – Jakarta – Singapore oSingapore – Bangkok – Singapore

§ Assume that the flight schedule is as below

(all flights available daily and for convenience all times are Singapore Time – ie: not local to the airport):

NOTE: *AeroLion is used as a reference of Airline reservation system. You can use any Airlines of your choice.

Ø Booking procedure:

§ Passengers approach the reservation staff and would specify the booking details:

o Number of Passengers oDate and Flight Number (origin, destination) oPassenger Names and details

· Details may be like, name and passport number etc.

o Assume that all passengers require seats, including infants below 2 years and all passengers would have the same price, no separate pricing for children, student, or Senior Citizen etc.

o Passengers may specify preferred seats, or just say Aisle or Window. Some passengers do not specify in which case, seat allocation is made by the system on a sensible basis. oIt is assumed that more than one booking staff would be working with the system at any given time

Ø Reporting feature

§ Passenger list by flight numbers

§ All flights by destination

§ All flights

§ Pie Chart – Revenue by destination (sector)

§ Barchart – Occupancy rate by day of the week

AeroLion wishes to have a simple yet elegant reservation system that could be used by its customers to book airline seats over the internet. AeroLion is aware of the rich and power packed features of ASP.NET and wish to use a rich client feel for the Customers and staff to maintain their data.

For the class project below 2 use cases need to be considered:

1) The system would require a feature for new customers to register – so a Customer Registration use case which may bare some relation to the maintain customer details use case may be required. The Customer Registration process is essential and customers may need to register before booking seats.

2) For the admin side, Flight administration use case, to be able to Create, Update, delete and Retrieve flights. This also includes to show a list for all flights

NOTE: *AeroLion is used as a reference of Airline reservation system. You can use any Airlines of your choice.