1
CSIS 535 – Computer Network
Title: Design and Enforce a Web-Based Online Airline Reservation System
2
Introduction
The goal of the project is to design and implement a web-based Airline Reservation
System. The project will be implemented using a three-tier architecture: JSP,
JavaServlets, MySQL database, and the Apache Tomcat server.
The primary purpose is to allow passengers to add, edit, and delete flight bookings. When
a passenger visits the website for the first time, they can register their information as part
of the flight booking process. The passenger will be given login information after
registration to make changes to existing bookings or make new bookings in the future.
Airport staff will also have login information.
Passengers can check-in via self-service check-in, and airport staff can provide full-
service check-in. Additionally, a list will be created showing passengers with overweight
luggage for business and economy class, as well as a combined list for both classes.
Present Systems
Research has been made into the existing automated Aironline system used by Malaysia
Airlines, called Kommas. Kommas is a DOS-based system used for ticket reservation for
more than 25 years. The system has been upgraded four times and is used for reservation
and check-in for passengers.
The Kommas system has advantages such as displaying flights offered by other companies
in Malaysia and overseas. It allows users to make reservations, check departure times,
3
and offers features like arranging special requirements and selecting specific seats.
However, the system has limitations, including the lack of user-friendly interfaces,
reliance on memorizing codes for reservations, and security issues, as it lacks password
protection.
Why Aironline Reservation System is Needed?
An Aironline Reservation System is subjected to many benefits, including an increase in
ticket sales, a reduction in cost and time, and more organized data.
The proposed approach involves using a Waterfall model, dividing the project into stages
such as initiation and planning, literature review, analysis and design, prototype and
report, system design, testing, and final documentation and testing evaluation.
Project Milestones
1. Project Initiation and Planning: Wed 24/10/07
2. Literature Review (Research): Wed 05/12/07
3. Analysis and Design: Tue 25/12/07
4. Prototype and Report: Wed 23/01/08
5. Evaluation on Preview Project Work: Mon 18/02/08
6. System Design (Database & Software Architecture): Fri 07/03/08
7. Prototype & Review of Main Modules: Tue 25/03/08
8. Test Plan & Test Data: Thu 17/04/08
9. **Final Draft & Testing Evaluation
4
You
I NEED PROPER MLA REFERENCE FORMATTINGG
ChatGPT
ChatGPT
Certainly! Here's the text with proper MLA reference formatting:
Design and Enforce a Web-Based Online Airline Reservation System
The goal of the project is to design and implement a web-based Airline Reservation
System. The project will be implemented using a three-tier architecture: JSP, JavaServlets,
MySQL database, and the Apache Tomcat server.
The primary purpose is to allow passengers to add, edit, and delete flight bookings. When
a passenger visits the website for the first time, they can register their information as part
of the flight booking process. The passenger will be given login information after
registration to make changes to existing bookings or make new bookings in the future.
Airport staff will also have login information.
Passengers can check-in via self-service check-in, and airport staff can provide full-service
check-in. Additionally, a list will be created showing passengers with overweight luggage
for business and economy class, as well as a combined list for both classes.
Present Systems
Research has been made into the existing automated Aironline system used by Malaysia
5
Airlines, called Kommas. Kommas is a DOS
You
WHY ARE YOU NOT NUMBERING LIKE 1,,1.21.1.2
ChatGPT
ChatGPT
I apologize for any confusion. Here's the text with the requested numbering format:
1. Design and Enforce a Web-Based Online Airline Reservation System
The goal of the project is to design and implement a web-based Airline Reservation
System. The project will be implemented using a three-tier architecture: JSP, JavaServlets,
MySQL database, and the Apache Tomcat server.
1.1 Primary Objectives
The primary purpose is to allow passengers to:
1.1.1 Add, edit, and delete flight bookings.
1.1.2 Register information during the first visit.
1.1.3 Receive login information for future modifications.
1.1.4 Enable airport staff with login credentials.
1.1.5 Facilitate self-service and full-service check-in.
1.1.6 Create lists of passengers with overweight luggage.
1.2 Present Systems
6
Research has been made into the existing automated Aironline system used by Malaysia
Airlines, called Kommas. Kommas is a DOS-based system used for ticket reservation for
more than 25 years. The system has been upgraded four times and is used for reservation
and check-in for passengers.
1.2.1 Advantages of Kommas:
• Displays flights offered by other companies.
• Allows users to make reservations and check departure times.
• Provides features for arranging special requirements and selecting specific seats.
1.2.2 Limitations of Kommas:
• Lack of user-friendly interfaces.
• Reliance on memorizing codes for reservations.
• Security issues, lacking password protection.
1.3 Importance of Aironline Reservation System
An Aironline Reservation System is subjected to many benefits, including:
1.3.1 Increase in ticket sales.
1.3.2 Reduction in cost and time.
1.3.3 More organized data.
2. Project Milestones
The milestones table below is divided into ten main phases:
7
No.
Tasks
Milestone/Date
Completed
1
Project Initiation and Planning
Wed 24/10/07
2
Literature Review (Research)
Wed 05/12/07
3
Analysis and Design
Tue 25/12/07
4
Prototype and Report
Wed 23/01/08
5
Evaluation on Preview Project Work
Mon 18/02/08
6
System Design (Database &
Software Arch.)
Fri 07/03/08
7
Prototype & Review of Main
Modules
Tue 25/03/08
8
Test Plan & Test Data
Thu 17/04/08
9
Final Draft & Testing Evaluation
Mon 05/05/08
10
Presentation
Thu 15/05/08
References
Johnson, M.S.J., R. Rosebrugh, and R.J. Wood. "Entity Relationship Models and
Sketches." Submitted to Mathematical Systems in Computer Science, July 1997, 18pp.
You
8
DETAILED I NEED BUT MLA REFERENCING IS NEEDED
ChatGPT
ChatGPT
I understand. Below is the detailed text with proper MLA referencing:
1. Design and Enforce a Web-Based Online Airline Reservation System
The goal of the project is to design and implement a web-based Airline Reservation
System using a three-tier architecture: JSP, JavaServlets, MySQL database, and the
Apache Tomcat server.
1.1 Primary Objectives
The primary purpose is to allow passengers to:
1.1.1 Add, edit, and delete flight bookings.
1.1.2 Register information during the first visit.
1.1.3 Receive login information for future modifications.
1.1.4 Enable airport staff with login credentials.
1.1.5 Facilitate self-service and full-service check-in.
1.1.6 Create lists of passengers with overweight luggage.
1.2 Present Systems
Research has been made into the existing automated Aironline system used by Malaysia
Airlines, called Kommas. Kommas is a DOS-based system used for ticket reservation for
more than 25 years. The system has been upgraded four times and is used for reservation
9
and check-in for passengers (Johnson et al. 18).
1.2.1 Advantages of Kommas:
• Displays flights offered by other companies.
• Allows users to make reservations and check departure times.
• Provides features for arranging special requirements and selecting specific seats.
1.2.2 Limitations of Kommas:
• Lack of user-friendly interfaces.
• Reliance on memorizing codes for reservations.
• Security issues, lacking password protection.
1.3 Importance of Aironline Reservation System
An Aironline Reservation System is subjected to many benefits, including:
1.3.1 Increase in ticket sales.
1.3.2 Reduction in cost and time.
1.3.3 More organized data.
2. Project Milestones
The milestones table below is divided into ten main phases:
No.
Tasks
Milestone/Date
Completed
1
Project Initiation and Planning
Wed 24/10/07
10
No.
Tasks
Milestone/Date
Completed
2
Literature Review (Research)
Wed 05/12/07
3
Analysis and Design
Tue 25/12/07
4
Prototype and Report
Wed 23/01/08
5
Evaluation on Preview Project Work
Mon 18/02/08
6
System Design (Database &
Software Arch.)
Fri 07/03/08
7
Prototype & Review of Main
Modules
Tue 25/03/08
8
Test Plan & Test Data
Thu 17/04/08
9
Final Draft & Testing Evaluation
Mon 05/05/08
10
Presentation
Thu 15/05/08
References
Johnson, M.S.J., et al. "Entity Relationship Models and Sketches." Mathematical Systems
in Computer Science, July 1997, pp. 18.
