develop an Internet based flight booking system for an Airline company named AeroLion

 

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):

FLIGHT FROM TO DEP ARR FARE
ALA 101 SIN KUL 0700 0800 $120
ALA 102 KUL SIN 0900 1000 $120
ALA 103 SIN KUL 1100 1200 $120
ALA 104 KUL SIN 1300 1400 $120
ALA 105 SIN KUL 20:00 21:00 $120
ALA 106 KUL SIN 22:00 23:00 $120
ALA 121 SIN BKK 0600 0900 $210
ALA 122 BKK SIN 10:00 13:00 $210
ALA 123 SIN BKK 14:30 17:30 $210
ALA 124 BKK SIN 18:30 21:30 $210
ALA 141 SIN CGK 15:00 16:30 $180
ALA 142 CGK SIN 17:30 19:00 $180

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.

 

find the cost of your paper

Complete independent research and review two (2) to three (3) online end-user license agreements.

Complete independent research and review two (2) to three (3) online end-user license agreements. Compare and contrast each EULA with each other. In your response, please consider the following: ·….

Write a SQL query that identifies the number of prescriptions grouped by drug name.

ALY6030 Final Project Assignment – Pharmacy Claims Due End of Week 6 Background: The excel file “ALY 6030 Final Project Data Set.xlsx” contains sample pharmacy claims for made-up members of….

Create a JavaFX program to allow a user to query the Northwind database.

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:   Print order total (not….