Online Airline Booking System Name Course Institution Date Online Airline Booking System System analysis and Design Introduction Science and technology has advanced and improved the everyday living of human lifecycle. It has made work very easy and fast to complete thus saving more and increasing profits. Today many organizations run on computer management systems and customer relationship systems (CMS). These type of systems are implemented to catch analyze store and retrieve the specified information by a click of a button. An example a category of a customer relationship system (CMS) is the Passenger Systems (PSS). This type of Customer relationship system (CMS) is implemented in handling a series of critical functions for a transport system and company (Irianto 2009). This article takes the approach of discussing the airline booking system as the main PSS. In an airline organization a reservation system or in some texts airline booking system is C. T. (2008). U.S. Patent No. 7 454 361. Washington DC: U.S. Patent and Trademark Office. Irianto A. (2009). Managing airline reservation system. Rajawali Pers. Law R. & Leung R. (2000). A study of airlines’ online reservation services on the Internet. Journal of Travel Research 39(2) 202-211. Levitan B. C. (2008). U.S. Patent No. 7 454 203. Washington DC: U.S. Patent and Trademark Office. Lynch M. F. & Turner J. A. (2005). U.S. Patent No. 6 839 679. Washington DC: U.S. Patent and Trademark Office. Mamaghani F. (2009). Impact of e-commerce on travel and tourism: An historical analysis. International Journal of Management 26(3) 365. Salvendy G. (2012). Handbook of human factors and ergonomics. John Wiley & Sons. Shelly G. B. & Rosenblatt H. J. (2011). Systems analysis and design. Cengage Learning. Zhao Y. Triantis K. Teodorović D. & Edara P. (2010). A travel demand management strategy: The downtown space reservation system. European Journal of Operational Research 205(3) 584-594. [...]
Project DeliverablesThe project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule.The deadline for the Individual Project can be found in the schedule section of the class syllabus. The following layout format covering a title page and all three phases is recommended for the project. Title page (project name, author, and date)Phase 1: Requirement analysisA. Problem definitionB. IssuesC. ObjectivesD. RequirementsE. ConstraintsF. Description of the proposed systemG. Logical model design1.Data flow diagrams•Context diagram•Diagram 0 oDiagram 1 ( Diagram 1 is optional) •Descriptions of processes in each diagram2.Descriptions of outputs/inputs/performance/security or controlsH. Specific requirements, if any (interface, operational, resource, performance, etc.)Phase 2: System and database designA. User interfaceDesign an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.1.How data will be input to the system?•The physical layout for each input•The input design and procedures2.How data will be output from the system?•The physical layout for each output•The output design and procedures B. Data designDevelop a plan for data organization, storage, updating, and retrieval. 1.Database design •Database tables with their attributes should be presented •Primary key(s) should be identified in each table, if any•Three steps of normalization should be included. 2.Entity-relationship diagrams3.Data file storage and accessC. System architectureDetermine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.Phase 3: Project planA list of tasks or activities needed for implementing the proposed systemEstimating completion time and costsA project schedule for performing those activities (Gantt charts or PERT charts)Note that there is no other required software package except the MS Project software in this course. As a result, you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software.