Design and Implementation of a WebBased Airline Reservation System

Design and Implementation of a Web-Based Airline Reservation System

Project / Seminar Material
Reference ID: PS-5136-TM

DEDICATION

This research material titled “Design and Implementation of a Web-Based Airline Reservation System” is dedicated to God for his enabling grace, and to all computer enthusiasts who contributed to make life a pleasant experience during my research documentation.

ACKNOWLEDGEMENT

I extend my sincere gratitude to all those who contributed to the completion of this project. Special thanks to my Supervisor (Name of your Supervisor), the Head of Department (Name of your HOD), the Lecturers in the department of Computer Science (CS), Book Authors and Profound Scholars of existing or related project material on “Design and Implementation of a Web-Based Airline Reservation System” for their invaluable guidance, support, and expertise throughout the journey.

I am also grateful to your study area (mention any funding organizations, if applicable) for their financial assistance. This research would not have been possible without the encouragement and assistance of some stakeholders (mention any mentors, teachers, or colleagues). Additionally, I would like to acknowledge the understanding and patience of my family and friends during this endeavor. Your unwavering support has been a constant source of motivation. Thank you all for being part of this meaningful endeavor.

TABLE OF CONTENTS

PRELIMINARY PAGES


CHAPTER ONE

INTRODUCTION


    CHAPTER TWO

    LITERATURE REVIEW

    • 2.1 Introduction

    CHAPTER THREE

    SYSTEM ANALYSIS AND DESIGN

    • 3.1 Methodology Adopted
    • 3.1.1 Problem Identification Using SSADM
    • 3.2 Analysis of the Existing System
    • 3.2.1 Dataflow of the Existing System
    • 3.2.2 Disadvantages Of The Existing System
    • 3.2.3 Weakness of the existing System
    • 3.3 Feasibility Study
    • 3.3.1 Economic Feasibility
    • 3.3.2 Technical Feasibility
    • 3.3.3 Operational Feasibility
    • 3.4 Analysis of the Proposed System
    • 3.4.1 Data Flow Diagram of the Proposed System
    • 3.4.2 Advantages of the Proposed System
    • 3.4.3 Justification of the Proposed System
    • 3.5 Functional Requirements
    • 3.5.1 Use Case Diagram Of The Admin / User Privileges
    • 3.6 Data Requirements
    • 3.7 High Level Model of the Proposed System

    CHAPTER FOUR

    SYSTEM DESIGN AND IMPLEMENTATION

    • 4.1 Objectives of the Design
    • 4.2 Cohesion and Decomposition High level Model
    • 4.3 Control Center / Overall Dataflow Diagram
    • 4.3.1 Proposed System Operation Flowchart
    • 4.4 System Specification and Design
    • 4.4.1 Input and Output Specification
    • 4.4.2 Database Specification and Design
    • 4.4.3 Data Dictionary
    • 4.5 Choice and Justification of Programming Language
    • 4.6 Program Documentation
    • 4.7 Implementation Techniques
    • 4.7.1 System Testing
    • 4.8 Programming Module Specification
    • 4.8.1 Installation
    • 4.9 Computer Hardware Minimum Requirement
    • 4.10 Software Requirement
    • 4.11 Personnel / User Training
    • 4.12 File Maintenance Module

    CHAPTER FIVE

    SUMMARY, CONCLUSION AND RECOMMENDATION

    • 5.1 Introduction
    • 5.2 Summary
    • 5.3 Conclusion
    • 5.4 Recommendation

    REFERENCES

    APPENDIX A - “SOURCE CODE”

    APPENDIX B - “OBJECT PROGRAM”

    ABSTRACT

    This work is aimed at the development of a web-based 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 new system that corrects this error. The new system will allow 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 will allow 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.

    This system will ensure enablement of online flight bookings, online access to passenger’s suggestions and complaints and a system that will enable online news publications for flight operators accessible to customers. The methodology adopted for this project is the Software Development Life Cycle (SDLC). The system is developed using PHP, MYSQL, JavaScript. This current system will make passenger airline relationship with the customers more flexible and reliable. This work successfully designed a web-based airline reservation system, solved the problem of passenger unavailability to cancel flight option and provides easy access to flight information.


    Design and Implementation of a Web-Based Airline Reservation System

    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. Reservation is the written record or promise of an arrangement by which accommodations are secured in advance. 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.


    1.2 Statement Of The Problem

    The current system of airline reservation is the manual method where a customer has to physical go to airport to book a flight. This current system is slow, time consuming and it is very difficult for each person to book through office agents. Users inquire about the tickets through phones and it is very difficult for the user to remember all the details that they received through phones. It is also difficult to calculate how many people registered and how many seats on a particular plane are vacant. This requires quite a lot of time and wastage of money as it requires quite lot of manpower to do. Among other shortcomings, the existing airline reservation system has the following shortcomings associated with it.

    1. Customers are not able to make cancellations after making reservation in an event where they are not able to travel again.
    2. The manual method of going to the airline desk to book flight is now obsolete and tasking.
    3. The airline sites are not open to customers suggestions and complaint.

    1.3 Objectives Of The Study

    The main objective of this study is to design a web-based reservation system which will automate the processes of airline ticket reservation, booking and airline management hence minimize errors resulting from manual system operations. To achieve the stated objective, the following specific objectives were laid out;

    1. To study the current system identifying its inefficiencies
    2. To design an online airline reservation information system to facilitate online booking and flight scheduling
    3. Provision of an option that will enable a passenger(s) to cancel his/her flight due to whim or impulse.
    4. Online access to passenger’s suggestions and complaints.
    5. A system that will enable online news publications for flight operators accessible to customers.

    1.4 Scope Of The Study

    The developed system is web-based hence will run on a browser which in turn requires an internet connection. This system will facilitate online booking; keep customer records, provides an online menu on flight schedules, flight destinations and their prices, show alternative links to other partner airlines and will have page dedicated to customer queries and replies. The system excludes catering for calculating staff salary and other management issue. For the sake of this project, a localhost server will be used instead of an online hosting system.


    1.5 Significance Of The Study

    From the viewpoint of the airline; the system will provide among other things the following; Minimize repetitive work done by the system administrator and reservation clerks. Maintain consistency among different access modes, e.g. by phone, by web, at the information desk and across different physical locations. Maintain customer information in case of emergency, e.g. flight cancellation due to inclement weather. Minimize the number of vacant seats on a flight and maximize flight capacity utilization Reduce effort and frustration for travelers in scheduling a trip, especially by reducing the search effort for the flight they need to take. In addition, the outcome of this study will provide a basis for developing the appropriate approach to the problems associated with air traveling operations in relation to Airline Reservation Systems.

    Also, this research work will be beneficial to those who travel a lot by air as it will reduce the stress involved in the manual system of reservation. For researchers, this work will serve as a reference point for researches.


    1.6 Definition Of Key Terms

    Airline Industry (Air Transport Industry):

    This is an area of commerce that uses aircraft to transport people, cargo, and mail. The air transport industry encompasses flights of common carriers (government-certified companies that offer cargo and passenger services to the public) and general aviation (private aircraft used for recreation or business

    Reservation:

    The written record or promise of an arrangement by which accommodations are secured in advance.

    System:

    This is any collection of component elements that work together to perform a task. In computer science, System is used in a variety of contexts. A computer System is a hardware system consisting of a microprocessor and allied chips and circuitry, plus an input device (keyboard, mouse, disk drive), an output device (monitor, disk drive), and any peripheral devices (printer, modem).

    Network:

    In computer science, a network is a system used to link two or more computers. Network users are able to share files, printers, and other resources; send electronic messages; and run programs on other computers Computerize: To control a function, process, or creation by a computer

    CHAPTER TWO

    2.0 Literature Review

    2.1 Introduction

    This chapter focuses on the review of related literature. A literature review includes the current knowledge as well as theoretical and methodological contributions to a particular topic. It documents the state of the art with respect to the topic you are writing. It surveys the literature in the topic selected. In this research work the literature review includes the …

    Summary Headlines for Design and Implementation of a Web-Based Airline Reservation System