Airline Reservation System

Introduction

Overview

The Project aim to design and implement a working model of an Airline Reservation System. The project will be built and tested on an Oracle database and uses JAVA as the programming language. JDBC will be use as the interface between the database and JAVA.

The primary goal of this project is to help passengers make flight reservation. The system will be able to find all the flights available fulfilling a passenger’s needs and able to search all flights with a given origin and destination. The system will displayed the arrival and departure times, the flight number and passenger will decide flight reservation based on the displayed information

What Citation Styles Can You Use for My Essay?

Students often ask, “Can you write my essay in APA or MLA?”—and the answer’s a big yes! Our writers are experts in every style imaginable: APA, MLA, Chicago, Harvard, you name it. Just tell us what you need, and we’ll deliver a perfectly formatted paper that matches your requirements, hassle-free.

The secondary goal is to provide a means for the airline operators to manager the flights. The operator will be able to put up lists of passengers with over-weight bags for Business and Economy class passengers

External Interface Requirements

User Interfaces:

The Web will be used as an interface with the users

Hardware Interfaces

No special hardware is required for this product

Software Interfaces:

Java

Is It Legal to Use Your Writing Service?

Absolutely, it’s 100% legal! Our service provides sample essays and papers to guide your own work—think of it as a study tool. Used responsibly, it’s a legit way to improve your skills, understand tough topics, and boost your grades, all while staying within academic rules.

JDBC

Apache Tomcat servlets

Oracle 8I SQL server

How Much Does It Cost to Get a Paper Written?

Our pricing starts at $10 per page for undergrad work, $16 for bachelor-level, and $21 for advanced stuff. Urgency and extras like top writers or plagiarism reports tweak the cost—deadlines range from 14 days to 3 hours. Order early for the best rates, and enjoy discounts on big orders: 5% off over $500, 10% over $1,000!

USE CASE Model

A user may obtain available seating information for flight between specified locations, for a given date.

A user may make a reservation for any available seat(s).

A user may cancel an existing reservation.

A user may than purchase the ticket.

Will My Use of This Service Stay Private?

Yes, totally! We lock down your info with top-notch encryption—your school, friends, no one will know. Every paper’s custom-made to blend with your style, and we check it for originality, so it’s all yours, all discreet.

The system functionality is described in more detail using UML

Static Model

In the model the concept of reservation has been simplified by requiring that all reservations be part of a group reservation, even if a group reservation is for a group of just one.

Figure 2. Normalized Information model of a flight seat reservation system annotated to convey meaning easily

Figure 3. Formalised dependency derived from figure 2. The X denotes inconsistent dependencies. and “1” the terminal object. This figure represents both theory and model.

Do You Use AI to Write Papers?

No way—our papers are 100% human-crafted. Our writers are real pros with degrees, bringing creativity and expertise AI can’t match. Every piece is original, checked for plagiarism, and tailored to your needs by a skilled human, not a machine.

Figure 4. modifies figure 3 by leaving out the detail of the terminal object. It adds in objects to support flights with multiple segments. A basic flight segment (flight_seg) is a leg of a flight that is the component of the flight between adjacent airports of the flight path.

The flight_seg* object is an expression of all contiguous flight path combinations of flight segments, including basic flight segments and segments that include other segments.

A static model of information is given in figure 2. The dependencies in this model are re-oriented in figure 3 to show the dependencies more clearly.

The dependencies to airport are inconsistent because airport is playing two roles (departure airport and arrival airport). The terminal object is specified by the property that every object must have a unique arrow to it. The terminal object can be interpreted as representing global properties of the system such as the airline company that has the reservation system.

Why Choose You for Research Papers?

We’re the best because our writers are degree-holding experts—Bachelor’s to Ph.D.—who nail any topic. We obsess over quality, using tools to ensure perfection, and offer free revisions to guarantee you’re thrilled with the result, even on tight deadlines.

Business Option

Why ARS is Needed

With Airline Reservation System implemented, the airlines may be subjected to many benefits, the benefits are as listed below: –

Increase in Sales of Tickets

With Airline Reservation System, I can track our passengers purchasing preferences and with this I can promote special flight packages to our existing passengers. Passengers’ reservations patterns can also be used to determine the marketable flight and then try to provide more flights and services to fulfill the high demand. Besides, ARS is also capable in increasing passenger loyalty and satisfaction by providing good reservation and services.

Reduce in Time and Cost

Traditional paper reservation records have many drawbacks: they can be incomplete, torn, worn, misplaced, or lost. They also require a lot of storage space in addition to requiring extensive administrative time from user. With the implementation of ARS, it will prevent data lost with back-up function and decrease in cost and time. It can increase the speed of searching, processing and making reservation. Thus, it gives satisfactory to passengers. From the data stored in the system, it is capable to generate daily/monthly sales report automatically. Users do not have to waste their time to generate the report manually.

More Organized Information

Flight ticket reservation method has better organization of information for better retrieval with ARS. All other relevant data can be managed and well-organized using the system. Data will be stored in the database accordingly. Thus, user can make a clear view on any data as they wish without any problem.

Who’s Writing My College Essays?

Our writers are top-tier—university grads, many with Master’s degrees, who’ve passed tough tests to join us. They’re ready for any essay, working with you to hit your deadlines and grading standards with ease and professionalism.

Technical Option

Below are the list of features the system should or most have:-

Add/Delete Airline Manager Information

Add/ Delete Ticketing Staff Information

Add/ Delete Flight Information

Are Your Papers Original?

Always! We start from scratch—no copying, no AI—just pure, human-written work with solid research and citations. You can even get a plagiarism report to confirm it’s 95%+ unique, ready for worry-free submission.

Add/Delete Passenger Information

Make Reservation

View/Query/Cancel Reservation

View/Query on Flight Information

Can You Match Any Citation Style?

You bet! From APA to IEEE, our writers nail every style with precision. Give us your guidelines, and we’ll craft a paper that fits your academic standards perfectly, no sweat.

View/Query on Passenger Information

View/Query on Airline Manager Information

View/Query on Ticketing Staff Information

Report on Flight, Passenger, Airline Manager and Ticketing Staff

Can I Update Instructions Mid-Order?

Yep! Use our chat feature to tweak instructions or add details anytime—even after your writer’s started. They’ll adjust on the fly to keep your essay on point.

Existing Systems

I have managed to do a research on the existing automated ARS used in Malaysia Airlines. The airlines reservation system used in Malaysia Airlines is known as KOMMAS.

KOMMAS is a DOS-base system that use by MAS for ticket reservation. This system has 25 years history. It had been upgrade for 4 times in these 25 years to add more features in it. Now, they still are using this system to do reservation for customers. All brunch of MAS in overseas are using the same system to do reservation too. The system can check on the departure time and day to specific place. Not only flights that offer by MAS but also flights offered by other airline systems in Malaysia and overseas.

For reservation, the reservation person will key in the record and book the tickets. Once booked, the system will check whether the flights or seats is confirm. This system has link to the capacity of the aircraft. For example, this system tells the number of seats occupied and empty seats for each class. If the seats had full, a note will pop up say that seats are full and confirm can not be made. By this function, the reservation person can tells the more accurately about which seats are available to customers.

The reservation person will then confirm with customers. Once confirm, the customers will go to the ticketing counter to take the ticket and pay the money. The reservation person will key in the reference number to the system. The information of customers will pop up if he had made the reservation.

How Do I Get an Essay Written?

Easy—place your order online, and your writer dives in. Check drafts or updates as you go, then download the final paper from your account. Pay only when you’re happy—simple and affordable!

The deadline for customers to take the tickets is 2 weeks before departure time. If the customers didn’t take the ticket and pay the money before these two weeks, the system will automatically erase the reservation. This is to enable others to do reservation. There is no deposit required in this process. For customers that want to change their flights departure time or date, the reservation person just need to key in the customer’s reference number and change the details. Customers also can cancel the flights if they couldn’t make it. The information of customers will keep by the system for 6 months. After 6 months, the system will automatically delete the passenger information.

This system also allows customers to make some special requirement. For example, some people may have elegy to certain food, the reservation person will key in this special requirement for food into the system, so that special meal will be provided to this person. Customers also can choose seat that they prefer. In the other words, this system is customers friendly. Booking is done by reservation department. But ticketing department also can access it and make reservation for customers. Ticketing and reservation department are link to each other, they can access the same database. KOMMAS have a specific code for the user of this system. For persons who make reservation and ticketing, they have the highest accessibility to use the system. For managing level, they just can access the system and check the report of flights and customer’s reservation information. For administration level of this system, they can customize the flights and departure time.

System down was happened before. When the system is down, all the ticketing reservation will do manually. The system also has backup the information of all flights and customers’ information. This is to prevent the damage of database due to virus or physical damage. So, there is no reason that they will lose their data.

However, this system has its weaknesses. It can not generate report according to the requirement of user. Also, this system has no basic intelligent. User will only get the report after one or two weeks. Due to this system is DOS base, the interface of this system may not attractive. Also, it is not user friendly enough for the user. User will need to memorize all the codes to make reservation, to view reports, to check on flight and etc. Information that shown out from the system is messy. For the beginner user of this system, they will face the difficulties to understand the information shown. For the security part, user do not have own password to get into the system. They get into the system just by using the access code that they had given.

How Fast Can You Handle Urgent Deadlines?

Super fast! Our writers can deliver a quality essay in 24 hours if you’re in a pinch. Pick your deadline—standard is 10 days, but we’ll hustle for rush jobs without skimping.

Project Plan

Gantt Chart

The first session of this project is to develop the system’s prototype and interim report. I have divided the first session of tasks into six different parts from Project initiation and planning until presentation. The first task is Project initiation and planning which start on 12 Oct. 2007.

Due to the deadline’s I will be expected to spend not more than two weeks to complete the first task. Than the next task is to work on Literature Review in this task I will be researching existing reference for the system and project, I will try to make contact with if possible visit a Local Airline office.

The Second session of this project will starts after the submission of interim report and prototype. I will start to prepare the final report; I have divided those tasks mainly on seven different parts from Review on preview project work until presentation.

On Thu 06/12/07, I planned to start a very crucial task, which is Analysis and Design. First I will have a analyze the requirement for this project and then I starts to design Entity Relational Diagram and Data Flow Diagram. It will consume most of the time in this task followed by drawing context diagram. The Analysis and Design is expected to finish on Tue 25/12/07. The final task before presentation is development prototype and Report, a prototype will be developed and it will consume most of the time while finalizing report will be the minor part in this task.

The first task that I need to do is review on preview project work, which start on Thu, 24/01/08 I will analyze what problem are to be solved and what improvement to be made and design a new project plan. The first task will be expected to spend eight days to complete.

Can You Tackle Complex Essay Topics?

Definitely! From astrophysics to literary theory, our advanced-degree writers thrive on tough topics. They’ll research deeply and deliver a clear, sharp paper that meets your level—high school to Ph.D.

The next task will be to update plan and requirement. After completing the review session, I will have the final update for the plan and project requirement. This plan should meet requirement in development a successful database CASE tool. This is expected to take five days to complete.

And than, System Design is next which is Database and Software Architecture. I will construct a database to the system for the purpose of enhancement; I will design on screen and repair the data model, which is expected to finish in eight days.

The next task is Prototype & Review of major modules in this task I will continue to work on the prototype which I have done during the interim report before staring the initial system coding, It is expected to finish Tue, 25/03/08

.After the implementation phase, I will go through the testing phase by constructing a Test Plan and Test Data. I will create an acceptance test and begin system debugging if problem occurs. And this is expected to finish Thu, 17/04/08

The following task is Final Report and Testing Evaluation. In this testing phase, I will continue on the final report, system testing and system evaluation. I will concentrate on the Final Report as well as System Completion towards the end of project development. I need to prepare a well-written and high-quality final report.

How Do You Meet My Professor’s Standards?

We tailor your paper to your rubric—structure, tone, everything. Our writers decode academic expectations, and editors polish it to perfection, ensuring it’s grade-ready.

The final task is the presentation of the project. A good preparation on this presentation phase will insure a good representation of the project.

Project Milestones l

In the milestones table, it’s mainly divided into four major phases, which the first phase completed by 1 November 2007 while the second phases are expected to be completed by 15 November 2007 including the review & presentation. And the final phases will be sub-divided into six tasks and the completion date for each task is stated as the table below