Airline Reservation System. I have attached the files
NOTE: *AeroLion is used as a reference of Airline reservation system. You can use any Airlines of your choice. DESCRIPTION OF THE SYSTEM 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 – o Singapore – Kuala Lumpur – Singapore o Singapore – Jakarta – Singapore o Singapore – 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 o Date and Flight Number (origin, destination) o Passenger 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. o It 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 PROJECT WEB DEVELOPMENT NOTE: *AeroLion is used as a reference of Airline reservation system. You can use any Airlines of your choice. Lab Assessment 2 – Practical Assessment Due date: Refer to Assignment Submission Box on VU Collaborate Weighting: 15% of total assessment Coverage: This assessment item is based on course content in Session 4- 5 Please find the Airline Reservation System Case Study in VUC. In this Assessment, you are NOT required to complete the entire project. Submission Requirements: Report (PDF file) To fulfil the requirements for assessment 2, you need to submit a report including the following contents: 1. List all possible views 2. List of controllers and actions for the 2 use cases with detailed description 3. Screenshots for all views and pages you have designed for this project. Source Code You are also required to submit a zipped file with all source code you have done to accomplish 2 use cases. You need to complete the following points at this moment: 1. Initialize ASP.NET Core MVC solution for this project 2. Create corresponding views, controllers and actions according to your report. 3. Complete design of views and pages indicated in your report. 4. You should present your web page professionally using your own design, NOT the same as in the sample file. 5. Appropriate user interaction and navigation should be considered for your application. 6. Your application should be ready to run without any further configuration Some Sample Screenshots are attached for your reference: A simple HomePage Page | 2 Customer Registration page when loaded in browser, looks as shown below This webform will contain few labels, textboxes and buttons as shown Page | 3 Marking Criteria Weight Marks Comments Report (20%) List of possible views 5 List of Controllers and Actions 10 Screenshots of all views created for this project 5 Source Code (30%) Views Design 10 Controllers Design 10 Sufficient Comments 5 Overall Project 5 PROJECT WEB DEVELOPMENT Lab Assessment 3 – Practical Assessment Due date: Refer to Assignment Submission Box on VU Collaborate Weighting: 15% of total assessment Coverage: This assessment item is based on course content in Session 6- 8 Please find the Airline Reservation System Case Study in VUC. Model Design Requirements You are going to design a model to store data for your application with the following specification: • The application should store information for the 2 use cases for which you created Views and Controllers in assignment 2. • You must design and implement the model classes to create the database and perform the CRUD operations as per the use cases. • Appropriate data annotations and input validations should be provided in all model classes. You should customize your own error messages and in addition, you can use the default error messages. In this Assessment, you need to continue your work done in lab assessment 2, and complete the entire project. Submission Requirements: Report (PDF file) To fulfill the requirements for assessment 3, you need to submit a report including the following contents: 1. A user manual including screenshots and description about how user can navigate through your application, view records as well as perform flight schedule administration. 2. List and Explain the validations that you have applied. 3. List the test cases for the CRUD operations and show the results using screenshots Source Code You are also required to submit a zipped file with all source code you have done to add the models and database. Further requirements for the project including: • Home page shows assignment name, student full name student id and location (campus). Display the logo of the airline company, on every page and link it to home page. • Develop the Model Architecture appropriately to perform the CRUD operations. • You should present your web page professionally using your own design, NOT the same as in the sample file. Page | 2 • Appropriate user interaction and navigation should be considered for your application. • Your application should be ready to run without any further configuration. Some Sample Screenshots are attached for your reference: Building a Simple UI Page Customer Registration page when loaded in browser, looks as shown below Page | 3 This webform will contain few labels, textboxes and buttons as shown Rubrics: Marking Criteria Weight Marks Comments Report (50%) User Manual - Screenshots 10 User Manual – Descriptions and Steps 10 Test Cases Design 15 Test Results – screenshots 15 Source Code (50%) Models and database 10 MVC architecture implementation 10 Data Annotations 5 Form Validation and Error Messages 5 Seeding Data 5 Sufficient Comments 5 Coding style 5 Project Completion 5 Model Design Requirements