Airline Reservation System

air passage Reservation system of rules excogitation OverviewThe Project aim to design and implement a realizeing ideal of an air passage Reservation System. The be after pull up stakes be built and substantially-tried on an Oracle database and uses JAVA as the programming language. JDBC testament be use as the interface between the database and JAVA.The primary goal of this sick is to help riders pretend course substitute. The constitution get out be fitting to find all the flights usable fulfilling a passengers request and able to search all flights with a given origin and destination. The trunk go away displayed the arrival and de break outure ms, the flight number and passenger forget decide flight reservation based on the displayed educationThe vicarious goal is to provide a means for the air passage meanss to manager the flights. The operator go out be able to put up identifys of passengers with over-weight bags for Business and providence class p assengersExternal Interface Requirements drug user Interfaces The Web volition be utilize as an interface with the usersHardw be InterfacesNo finical computer hardw be is required for this productSoftware Interfaces JavaJDBCApache Tomcat servletsOracle 8I SQL innkeeperUSE CASE ModelA user whitethorn bind available seating information for flight between specified locations, for a given date.A user may restrain a reservation for any available seat(s).A user may slewcel an active reservation.A user may than purchase the tatter.The dodging functionality is described in more detail victimization UMLStatic ModelIn the beat 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. range 2. Normalized teaching model of a flight seat reservation agreement annotated to convey meaning easilyFigure 3. Formalised dependency derived from figure 2. The X de flavors unsuita ble dependencies. and 1 the terminus tendency. This figure represents both theory and model.Figure 4. modifies figure 3 by leaving out the detail of the terminal heading. It adds in objects to support flights with septuple segments. A underlying 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 separate 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 e rattling object must welcome a unique arrow to it. The terminal object can be interpreted as representing g lobal properties of the trunk such as the airline company that has the reservation outline.Business OptionWhy ARS is Needed With Airline Reservation System implemented, the airlines may be subjected to some(prenominal) 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 limited flight packages to our existing passengers. Passengers reservations patterns can in any case be used to chequer the marketable flight and then try to provide more flights and run 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 ca-ca many drawbacks they can be incomplete, torn, worn, misplaced, or lost. They also require a smoke of storage space in addition to requiring extensive administrative cadence from user . With the implementation of ARS, it go forth balk data lost with back-up function and devolve in cost and m. It can increase the speed of searching, processing and devising reservation. Thus, it gives satisfactory to passengers. From the data stored in the form, it is capable to grow daily/ periodical sales make known automatically. Users do not let to waste their time to generate the report manually.More Organized Information Flight ticket reservation method has better organization of information for better convalescence with ARS. All other relevant data can be managed and well-organized using the system. Data leave be stored in the database accordingly. Thus, user can make a clear view on any data as they wish without any problem.Technical OptionBelow are the list of features the system should or most have- join on/Delete Airline private instructor InformationAdd/ Delete Ticketing Staff InformationAdd/ Delete Flight InformationAdd/Delete Passenger InformationMake Rese rvation thinking/Query/Cancel ReservationView/Query on Flight InformationView/Query on Passenger InformationView/Query on Airline Manager InformationView/Query on Ticketing Staff Information calculate on Flight, Passenger, Airline Manager and Ticketing StaffExisting 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 historic period 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 someone allow for key in the record and book the tickets. Once booked, the system will check whether the flights or seating room 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 plentiful, a note will pop up say that seats are full and confirm can not be do. 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.The deadline for customers to take the tickets is 2 weeks onwards departure time. If the customers didnt take the ticket and pay the money forwards these two weeks, the system will automatica lly erase the reservation. This is to enable others to do reservation. There is no deposit required in this process. For customers that want to transform their flights departure time or date, the reservation person just essential to key in the customers reference number and throw the details. Customers also can cancel the flights if they couldnt 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 requiem 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 custome rs. 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 customers reservation information. For administration level of this system, they can sew 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 fatherner 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.Project computer programGantt ChartThe head start sitting of this project is to develop the systems prototype and interim report. I have divided the first of all session of lying-ins into six different parts from Project initiation and planning until presentation. The first labor movement is Project initiation and planning which start on 12 Oct. 2007.Due to the deadlines I will be expected to pass along not more than two weeks to complet e the first parturiency. Than the adjoining labor movement 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 introduction of interim report and prototype. I will start to prepare the terminal report I have divided those tasks mainly on heptad different parts from Review on trailer project work until presentation.On Thu 06/12/07, I planned to start a very crucial task, which is Analysis and build. First I will have a crumble the requirement for this project and then I starts to design Entity comparative Diagram and Data Flow Diagram. It will consume most of the time in this task followed by drawing context diagram. The Analysis and object 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 trance finalizing report will be the minor part in this task.The first task that I need to do is examine 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.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 sure-fire database CASE tool. This is expected to take five days to complete.And than, System public figure 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 sort out 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 o n 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 prove send off 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/08The following task is Final Report and examination 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.The final task is the presentation of the project. A good preparation on this presentation phase will check over a good representation of the project.Project Milestones lIn the milestones table, its mainly divided into four major phases, which the first phase absolute by 1 Novembe r 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 No.TasksMilestone/Date Completed1Project Initiation and Planning Wed 24/10/072Literature Review (Research)Wed 05/12/073Analysis and DesignTue 25/12/074Prototype and ReportWed 23/01/085. Review on Preview Project WorkMon 18/02/086.System Design ( Database Software Architechit)Fri 07/03/087.Prototype Review of major ModulesTue 25/03/088.Test Plan Test DataThu 17/04/089.Final Draft Testing EvaluationMon 05/05/0810.PresentationThu 15/05/08Table 1.1 Project Milestones ReferenceJohnson, M.S.J., R. Rosebrugh and R.J. Wood, 1997. Entity consanguinity models and sketches, submitted to Mathematical Structures in Computer Science, July, 1997, 18pp.