AN ONLINE AIRLINE RESERVATION INFORMATION SYSTEM …
[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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- chapter 1 mis and you california state university
- strategic information systems for competitive advantage
- student self administered case study it 45 60
- introduction to management information systems
- information systems definitions and components
- management information system implementation challenges
- case study an information system management model
- information systems for business and beyond
- the impact of management information systems on the
- an online airline reservation information system
Related searches
- information system organization and strategy
- information system in business pdf
- information system definition pdf
- information system definition and purpose
- role of information system in organization
- information system pdf download
- business information system pdf
- information system professionals
- management information system definition pdf
- financial information system pdf
- introduction to information system pdf
- teachers certification information system nj