AN ONLINE AIRLINE RESERVATION INFORMATION SYSTEM CASE ...

[Pages:61]RESEARCH PAPER

AN ONLINE AIRLINE RESERVATION INFORMATION SYSTEM

CASE STUDY: RWENZORI AIRLINES

BY

THEMBO JIMMY [IT TECHNICIAN KYAMBOGO UNIVERSITY]

i

TABLE OF CONTENTS

LIST OF TABLES .................................................................................................................... iv LIST OF FIGURES .................................................................................................................. vi LIST OF ABBREVIATIONS.................................................................................................. viii ABSTRACT ............................................................................................................................. ix CHAPTER ONE .......................................................................................................................1

1.0 Introduction .......................................................................................................................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.0.Introduction .......................................................................................................................4 2.1 History of Airline Reservation Information System............................................................4 2.2Reservation Information Systems........................................................................................5 2.3 Components of Reservation Information Systems ..............................................................6 2.3.1 Hardware.....................................................................................................................7 2.3.2 Software......................................................................................................................7 2.3.3 Data ............................................................................................................................7 2.3.4 People .........................................................................................................................7 2.3.5 Procedures...................................................................................................................8 2.3.6 Database......................................................................................................................8 2.4 Types of Reservations in Reservation System ....................................................................8 2.5 Types of Information System .............................................................................................9 2.5.1 Transaction Processing System (TPS)..........................................................................9

ii

2.5.3 Management Information System (MIS)......................................................................9 2.5.4 Decision-support systems (DSS)................................................................................10 2.5.5 Executive Support System (ESS)...............................................................................10 2.6 Application of Reservation Systems.................................................................................10 2.7 Advantages of Reservation Information Systems .............................................................10 2.8 Limitations of Reservation Information System ...............................................................11 CHAPTER THREE ................................................................................................................12 METHODOLOGY .................................................................................................................. 12 3.0 Introduction ...................................................................................................................12 3.1 System Study and Analysis ..............................................................................................12 3.1.1 Interviews..................................................................................................................12 3.2.2 Questionnaire ............................................................................................................13 3.3 Requirements Determination............................................................................................14 3.3.1 Requirements Analysis ..............................................................................................14 3.4 System Design .................................................................................................................14 3.5 System Implementation....................................................................................................15 3.6 System Testing ................................................................................................................15 3.7 System Validation............................................................................................................16 CHAPTER FOUR...................................................................................................................17 SYSTEM DESIGN, ANALYSIS AND IMPLEMENTATION..............................................17 4.0 Introduction .....................................................................................................................17 4.1 System Design Objectives................................................................................................17 4.2 System Design .................................................................................................................18 4.2.1 Logical design ...........................................................................................................18 4.2.2 Conceptual design .....................................................................................................18 4.2.3 Physical design..........................................................................................................18 4.3 Functional Requirements .................................................................................................19 4.4 Non-functional requirements............................................................................................19 4.5 Data Flow Diagrams ........................................................................................................20 4.5.1 Context Diagram for Airline Reservation System ......................................................22

iii

4.5.3 Level One Data Flow Diagram for Reservation Process.............................................23 4.6 System Component Interactions.......................................................................................23 4.7 Database design ...............................................................................................................24

4.7.1 Entities ......................................................................................................................24 4.7.3 An Entity Relationship Diagram for Airline Reservation ...........................................25 4.7.4 Database Conceptual Design .....................................................................................26 4.7.5 Table Attribute Description (Physical Design)...........................................................26 4.8 System Implementation....................................................................................................29 4.8.1 System Users.............................................................................................................30 4.8.2 Implementation Requirements ...................................................................................31 4.8.3 System Execution Sequence ......................................................................................31 CHAPTER FIVE.....................................................................................................................44 FINDINGS, CONCLUSION AND RECOMMENDATIONS ...............................................44 5.0 Introduction .....................................................................................................................44 5.1 Findings...........................................................................................................................44 5.2 Conclusion.......................................................................................................................45 5.3 Conversion ......................................................................................................................46 5.4 Recommendations............................................................................................................46 References ................................................................................................................................47 APPENDICES .........................................................................................................................49 Appendix A: Interview Guide Questions...............................................................................49 Appendix B: Questionnaire...................................................................................................50

LIST OF TABLES

iv

Table 1: Showing Passengers details .......................................................................................27 Table 2: Showing Flight details ................................................................................................27 Table 3: Showing Payment details ............................................................................................28 Table 4: Showing Journey details .............................................................................................28 Table 5: Showing Schedule details ...........................................................................................29

v

LIST OF FIGURES

Figure 2.1: Showing a global distribution system .......................................................................6 Figure 2.2: Five Stages of Transaction Processing System..........................................................9 Figure 3.1: The system study and design model........................................................................12 Figure 4.1: Showing a context diagram for a reservation system...............................................22 Figure 4.2: Level one data flow diagram for the reservation process...................................23 Figure 4.3: Showing interconnectivity of the different system components...............................24 Figure 4.4: Showing an entity relationship diagram for airline reservation system ....................25 Figure 4.5: Showing the data base logical design for an airline reservation system ...................26 Figure 4.6: Administrator use case diagram..............................................................................30 Figure 4.7: Customer use case diagram ....................................................................................30 Figure 4.8: Showing a Guest User case diagram .......................................................................31 Figure 4.9: Showing the Welcome Interface .............................................................................32 Figure 4.10: Showing Customer Registration Form ..................................................................32 Figure 4.11: Showing the Customer Search Interface ...............................................................33 Figure 4.12: Showing a Full Customer Record Interface...........................................................34 Figure 4.13: Showing Journey details Interface ........................................................................35 Figure 4.14: Showing Rwenzori Airlines Schedules .................................................................35 Figure 4.15: Showing flight Reservations, Ticket Reservation and Cancel Interface .................36 Figure 4.16: Showing a Flight Booking Form...........................................................................36 Figure 4.17: Showing Ticket Booking Form.............................................................................37 Figure 4.18: Showing Ticket detail interface ............................................................................38 Figure 4.19: Showing ticket Cancelation Interface....................................................................38 Figure 4.20: Showing Customer Contact us Page/Interface.......................................................39

vi

Figure 4.21: Showing Administrators Password Interface .......................................................40 Figure 4.22: Showing Administrators Home Interface ..............................................................40 Figure 4.23: Showing change password change interface .........................................................41 Figure 4.24: Showing database interface ..................................................................................41 Figure 4.25: Showing flight schedule interface .........................................................................42 Figure 4.26: Showing journey entry form.................................................................................42 Figure 4.27: Showing add ticket interface.................................................................................43 Figure 4.28: Showing flight information interface ....................................................................43

vii

ARS: CASE: CRS: DB : DBMS : DDL : DFD : DML: DSS: EG: ERD: FK: GB: GDS: GUI: HTML: MB: MHz: MIS: PHP:

PK: PSS: RAM: TCP/IP: TPS:

LIST OF ABBREVIATIONS

Air Reservation System Computer-Aided Software Engineering Computer Reservation System Data Base Database Management System Data Definition Language Data Flow Diagram Data Manipulation Language Decision Support Systems Example Given Entity Relationship Diagram Foreign Key Giga Byte Global Distribution System Graphical User Interface Hypertext Markup Language Mega Byte Mega Hertz Management Information Systems Hypertext Preprocessor

Primary Key Passenger Service System Random Access Memory Transmission Control Protocol/ Internet Protocol Transaction Processing Systems

viii

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download