Design and Implementation of an Online Airline Reservation Information System

Design and Implementation of an Online Airline Reservation Information System

ABSTRACT

Airline Reservation Systems (ARS) used to be standalone systems. Each airline had its own system, disconnected from other airlines or ticket agents, and usable only by a designated number of airline employees.

Travel agents in the 1970s pushed for access to the airlines’ systems. Today, air travel information is linked, stored, and retrieved by a network of Computer Reservations Systems (CRS), accessible by multiple airlines and travel agents.

This report is a summary of the study that was undertaken to design and implement an airline reservation system. The airline reservation system designed in this project was developed using php, java script and html as the programming languages and MySQL as the database Management system.

The researcher reviewed the literature of reservation systems in chapter two and explored the advantages and limitations of reservation system in real life situations.

PROCEED NOW TO DOWNLOAD PAGE

TABLE OF CONTENTS 

ABSTRACT…………………………………………………………………………………………………………….. ix

CHAPTER ONE ………………………………………………………………………………………………………..1

1.1 Background of the Study ……………………………………………………………………………………….1

1.2 Problem statement ……………………………………………………………………………………………….2

1.3 Objectives …………………………………………………………………………………………………………..2

1.3.1 General Objective …………………………………………………………………………………………..2

1.3.2 Specific Objectives …………………………………………………………………………………………2

1.4 Scope of the Study ……………………………………………………………………………………………….3

1.5 Significance of the Study ………………………………………………………………………………………3

CHAPTER TWO ……………………………………………………………………………………………………….4

LITERATURE REVIEW ……………………………………………………………………………………………4

2.1 History of Airline Reservation Information System ……………………………………………………4

2.2Reservation Information Systems …………………………………………………………………………….5

• Components of Reservation Information Systems ……………………………………………………..6
  • ……………………………………………………………………………………………………..7
  • Software ……………………………………………………………………………………………………….7
  • Data …………………………………………………………………………………………………………….7
  • People ………………………………………………………………………………………………………….7
  • Procedures …………………………………………………………………………………………………….8
  • Database ……………………………………………………………………………………………………….8
• Types of Reservations in Reservation System …………………………………………………………..8
• Types of Information System …………………………………………………………………………………9
  • Transaction Processing System (TPS)………………………………………………………………..9
  • Management Information System (MIS) …………………………………………………………….9
  • Decision-support systems (DSS)…………………………………………………………………….. 10
  • Executive Support System (ESS) ……………………………………………………………………. 10
• Application of Reservation Systems ……………………………………………………………………… 10
• Advantages of Reservation Information Systems ……………………………………………………. 10
• Limitations of Reservation Information System ……………………………………………………… 11

CHAPTER THREE ………… 12

METHODOLOGY …………… 12

3.1 Overview…. ……………………………………………………………………………………………………. 12

• System Study and Analysis ………………………………………………………………………. 12

3.1.2 Interviews…………………………………………………………………………………………………… 12

3.2.2 Questionnaire ……………………………………………………………………………………………… 13

3.3 Requirements Determination……………………………………………………………………………….. 14

3.3.1 Requirements Analysis …………………………………………………………………………………. 14

• Output Design……………………………………………………………………………………………………. 14
• System Implementation………………………………………………………………………………………. 15
• System Testing …………………………………………………………………………………………………. 15
• Database Structure ……………………………………………………………………………………………… 16

CHAPTER FOUR …….. 20

SYSTEM DESIGN, ANALYSIS AND IMPLEMENTATION………………………………………. 20

• System Design Objectives………………………………………………………………………………. 20

4.2 System Design……………………………………………………………………………………………… 21

• Logical design…………………………………………………………………………………………….. 21
• Conceptual design……………………………………………………………………………………….. 21
• Physical design ……………………………………………………………………………………………. 21

• Functional Requirements ……………………………………………………………………………………. 22
• Non-functional requirements……………………………………………………………………………….. 22
• Data Flow Diagrams………………………………………………………………………………………….. 23

4.5.1 Context Diagram for Airline Reservation System ……………………………………………… 25

4.5.3 Level One Data Flow Diagram for Reservation Process ……………………………………… 26

• System Component Interactions…………………………………………………………………………… 27
• Database design ………………………………………………………………………………………………… 28

4.7.1 Entities ………………………………………………………………………………………………………. 28

• An Entity Relationship Diagram for Airline Reservation ……………………………………. 28
• Database Conceptual Design …………………………………………………………………………. 28
• Table Attribute Description (Physical Design) ………………………………………………….. 29

4.8 System Implementation………………………………………………………………………………………. 31

• System Users ………………………………………………………………………………………………. 31
• Hardware Platform………………………………………………………………………………………. 32
• Hardware Platform……………………………………………………………………………………… 32
• System Execution Sequence………………………………………………………………………….. 33

CHAPTER FIVE……………………………………………………………………………………………………… 46

FINDINGS, CONCLUSION AND RECOMMENDATIONS……………………………………….. 46

• Findings …………………………………………………………………………………………………………… 46
• ………………………………………………………………………………………………………. 47
• Conversion ………………………………………………………………………………………………………. 47
• …………………………………………………………………………………………….. 48

References……………………………………………………………………………………………………………….. 49

PROCEED NOW TO DOWNLOAD PAGE

INTRODUCTION

In science and technology, the desire for improvement is a constant subject which triggers advancements. This is visible in every ramification and the airline industry is not an exemption.

Airline reservation systems were first introduced in the late 1950s as relatively simple standalone systems to control flight inventory, maintain flight schedules, seat assignments and aircraft loading.

Today modern airline reservation systems are comprehensive suites of products to provide systems that assist with a variety of airline management tasks and service customer needs from the time of initial reservation through completion of the flight.

The World Wide Web has become tremendously popular over the last four years, and currently, most of the airlines have made provision for online reservation of their flights.

PROCEED NOW TO DOWNLOAD PAGE

References

Airline, 2012  http://www.enotes.com/topic/Airline_Reservations_System retrieved on May 2012
Alter, S. L. (1980). Decision support systems: current practice and continuing challenges. Reading, Mass., Addison-Wesley Pub. Aviation and Space. Retrieved on May 20, 2012 from Microsoft Encarta Premium Encyclopedia.
Winston, S. Morrison (1995): “The Evolution of the Airline Industry”, Brookings Institution Press, South Dakota, Cf. p. 61-62, Computer Reservation Systems.
Diane (1993) Computer Reservation Systems: “Action Needed to Better Monitor the CRS           Industry and Eliminate CRS Biases”, DIANE Publishing Company,  ISBN1568069774
European Parliament: “More Competition in Airline Reservation System – With
Finley, P. N. (1994). Introducing decision support systems. Oxford, UK Cambridge, Mass.           NCC Blackwell; Blackwell Publishers. 

PROCEED NOW TO DOWNLOAD PAGE