DESIGN AND IMPLEMENTATION OF AIRLINE RESERVATION SYSTEM

DESIGN AND IMPLEMENTATION OF AIRLINE RESERVATION SYSTEM

ABSTRACT

This work is aimed at design and implementation of Airline Reservation System. The current system of airline reservation is faced with few technical issues, ranging from not allowing passengers to cancel their reservations as well as does not provide functionality for passengers to view price chart. This calls for the need to develop a system that corrects this error. The design Computerized Airline Reservation System stores and retrieves information and conduct transactions related to air travels. The present system allows the passenger to cancel his/her reservation, if any problem occurs and view price chat which did not occur in the old system. This system allows the airline passengers to search for flights that are available between the two travel cities, namely the “Departure city” and “Destination city” for a particular departure and arrival dates. The methodology adopted for this project is the Structured System Analysis and Design Methodology (SSADM). The new system displays all the flight’s details such as flight number, name, price and duration of journey etc. After search the system display list of available flights and allows customer to choose a particular flight. Then the system checks for the availability of seats on the flight. Then it checks the validity of card and book the flight.

TABLE OF CONTENTS

Page

Title page                                                           i

Certification                                                        ii

Approval                                                            iii     

Dedication                                                          iv

Acknowledgement                                               v

Abstract                                                             vi

Table of Content                                                  vii

List of Tables                                                      x

List of Figures                                                     x

CHAPTER ONE: INTRODUCTION

1.1        Background of the Study                              1     

1.2        Statement of the Problem                             3

1.3        Objectives of the Study                                        3

1.4        Scope of the Study                                      4

1.5        Significance of the Study                              4     

1.6        Limitation of the Study                                         4

1.7        Definition of Terms                                      5

CHAPTER TWO: LITERATURE REVIEW

2.1    Introduction                                                7

2.2    Reservation System                                     8

2.3    Online Reservation                                       9

2.4    Online Travel Agencies                                 10

2.5    History of Airline Reservation System (ARS)     11

2.6    Aero Contractors – Brief History                     14

CHAPTER THREE: METHODOLOGY AND ANALYSIS OF THE PRESENT SYSTEM

3.1    Methodology                                               15

3.1.1 Problem Identification                                  16

3.1.2 Feasibility Studies                                        16

3.1.3 Requirement Analysis                                   18

3.1.4 Requirement Specifications                           19

3.2    Analysis of the Present System                      26

3.2.1 Analysis of the Proposed System                    27    

3.2.2 Weaknesses of the present Aero Airline

Reservation System                                     27

3.2.3 High Level Model Diagram for the

Proposed Solution                                        28

CHAPTER FOUR: SYSTEM DESIGN AND IMPLEMENTATION

4.0    Introduction                                                29    

4.1    System Design                                            29

4.2    Database Design                                         29

4.3    System Flow chats                                       33

4.4    Documentation                                            37

4.5    Testing Phase                                             38

4.5.1 System Testing                                           39

4.5.2 Unit Testing                                                39

4.5.3 Integrating Testing                                      41

4.5.4 Validation                                                   41

4.5.5 Compilation Test                                          41

4.5.6 Execution Test                                            42

4.5.7 Output Test                                                 42

4.6    Implementation                                           42

4.7    Choice of Programming Language Used        43

4.8    Requirements                                             44

4.8.1 Hardware Requirements                               44

4.8.2 Software Requirements                               44

CHAPTER FIVE

Summary                                                           46

Conclusion                                                          46

Recommendation                                                47

References                                                         48

Appendix A                                                         49

Appendix B                                                         65

LIST OF TABLES

Table 4.1 Database table for Fares                       31

Table 4.2 Database table for Passenger List         31

Table 4.3 Database table for Register User          32

Table 4.4 Database for Schedule1 table               32

LIST OF FIGURES

Fig 3.1 High level model Diagram of Proposed System28

Fig 4.1Flowcharts for finding flights                         33

Fig 4.2Flowcharts for checking flight details             34

Fig 4.3Flowcharts for passenger information            35

Fig 4.4Flowcharts for cancel reservation                  36

CHAPTER ONE

INTRODUCTION

1.1   BACKGROUND OF THE STUDY

Online Air Ticketing is a kind of user assistance where customers can book tickets for flight online. This is an easy method which saves a lot of time. 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. The modern Airline Reservation System is comprehensive suite of products to provide a system that assists with a variety of airline management tasks and service customer needs from the time of initial reservation through completion of the flight.  One of the most common modes of travel is traveling by air. Customers who wish to travel by air nowadays have a wide variety of airlines, and a range of timings to choose from. Nowadays competition is so fierce between airlines that there are lot of discounts and a lot of luxuries given to customers that will give an edge to that particular airline. 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. The Internet has become a major resource for people looking for making reservations online without the hassle of meeting travel agents(Wikipedia, 2010.)

Reservation is the written record or promise of an arrangement by which accommodations are secured in advance (WordWeb 5.1, WordNet Database.)

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. The global distribution system (GDS) makes for an even larger web of airline information, not only merging the buying and selling of tickets for multiple airlines, but also making the systems accessible to consumers directly. GDS portals and gateways on the Web allow consumers to purchase tickets directly, select seats, and even book hotels and cars rental (Winston, Clifford 1995.)

1.2   STATEMENT OF PROBLEM

The existing aero airline reservation system has the following shortcomings associated with it.

      i.        Customers are not able to make cancellations after making reservation in an event were they are not able to travel again.

     ii.        The aero airline sites do not allow customers to view price chart.

1.3   OBJECTIVES OF THE STUDY

The objective of this study is to develop software that will:-

      i.        Provide an option that will enable a passenger(s) to cancel his/her flight due to whim or impulse.

     ii.        Provide an option where passengers can view price chart.

TOPIC: DESIGN AND IMPLEMENTATION OF AIRLINE RESERVATION SYSTEM

Chapters: 1 - 5
Delivery: Email

Number of Pages: 70

Price: 3000 NGN

In Stock

Buy the Complete Material Now