TABLE OF CONTENTS
LIST OF TABLES - iv
LIST OF FIGURES vi
LIST OF ABBREVIATIONS viii
ABSTRACT - - ix
CHAPTER ONE - 1
11 Background of the Study - 1
12 Problem statement - - 2
13 Objectives - - 2
131 General Objective - 2
132 Specific Objectives - 2
14 Scope of the Study - - 3
15 Significance of the Study - 3
CHAPTER TWO - 4
LITERATURE REVIEW - - 4
21 History of Airline Reservation Information System - - 4
22Reservation Information Systems - 5
23Components of Reservation Information Systems - - 6
231Hardware - 7
232Software - 7
233Data - - 7
234People - - 7
235Procedures - 8
236Database - 8
24Types of Reservations in Reservation System - 8
25Types of Information System - - 9
251Transaction Processing System (TPS) - - 9
2
53Management Information System (MIS) - 9
254Decision-support systems (DSS) 10
255Executive Support System (ESS) - - - 10
26Application of Reservation Systems 10
27Advantages of Reservation Information Systems - - 10
28Limitations of Reservation Information System - - - 11
CHAPTER THREE 12
METHODOLOGY 12
31 Overview - 12
311System Study and Analysis 12
312 Interviews 12
322 Questionnaire - - 13
33 Requirements Determination - - 14
331 Requirements Analysis - - 14
34Output Design - 14
35System Implementation - 15
36System Testing 15
37Database Structure - - 16
CHAPTER FOUR - 20
SYSTEM DESIGN, ANALYSIS AND IMPLEMENTATION - - 20
41System Design Objectives - - 20
42 System Design - - 21
421Logical design - - 21
422Conceptual design - 21
423Physical design - - 21
43Functional Requirements 22
44Non-functional requirements - - 22
45Data Flow Diagrams - 23
451 Context Diagram for Airline Reservation System - 25
453 Level One Data Flow Diagram for Reservation Process - - 26
46System Component Interactions - 27
47Database design - - - 28
471 Entities - 28
473An Entity Relationship Diagram for Airline Reservation - - 28
474Database Conceptual Design - 28
475Table Attribute Description (Physical Design) - - 29
48 System Implementation - 31
481System Users - - 31
482Hardware Platform - 32
483Hardware Platform - 32
484System Execution Sequence - 33
CHAPTER FIVE - 46
FINDINGS, CONCLUSION AND RECOMMENDATIONS - - - 46
51Findings - - 46
52Conclusion - 47
53Conversion - 47
54Recommendations - - 48
References 49
APPENDICES - - 51
Appendix 1: Terminology 51
Appendix 2: Programming Listing - 53
Appendix 3: Sample Data - 72
Appendix 4: Flow Chart - 79
LIST OF TABLES
Table 1: Showing Customer’s details - 27
Table 2: Showing Flight details 27
Table 3: Showing Journey details - - 28
Table 4: Showing User details - - 28
LIST OF FIGURES
Figure 21: Showing a global distribution system - 6
Figure 22: Five Stages of Transaction Processing System - - 9
Figure 31: The system study and design model - 12
Figure 41: Showing a context diagram for a reservation system - - - 22
Figure 42: Level one data flow diagram for the reservation process - - 23
Figure 43: Showing interconnectivity of the different system components - - - 24
Figure 44: Showing an entity relationship diagram for airline reservation system - 25
Figure 45: Showing the data base logical design for an airline reservation system - 26
Figure 46: Administrator use case diagram - - 30
Figure 47: Customer use case diagram - 30
Figure 48: Showing the Welcome Interface - - 32
Figure 49: Showing Customer Registration Form 32
Figure 410: Showing the Customer Search Interface - - - 33
Figure 411: Showing a Full Customer Record Interface - - 34
Figure 412: Showing Journey details Interface - 35
Figure 413: Showing Rwenzori Airlines Schedules 35
Figure 414: Showing flight Reservations, Ticket Reservation Interface 36
Figure 415: Showing a Flight Booking Form - - 36
Figure 416: Showing Ticket Booking Form - - 37
Figure 417: Showing Ticket detail interface - - 38
Figure 418: Showing ticket Cancelation Interface - 38
Figure 419: Showing Customer Contact Us Page/Interface - 39
Figure 420: Showing Administrators? Password Interface - 40
Figure 421: Showing Administrators Home Interface - - 40
Figure 422: Showing change password change interface - - 41
Figure 423: Showing database interface 41
Figure 424: Showing flight schedule interface - - 42
Figure 425: Showing journey entry form 42
Figure 426: Showing add ticket interface 43
Figure 427: Showing flight information interface - 43
