COMPUTERIZATION OF AIRLINE RESERVATION SYSTEM
ABSTRACT
An Airline Reservation Information System is a computerized system used to store and retrieve information and conduct transactions related to travel. The aim of the study is to Design and Implement a Computerized Airline Reservation System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will minimize cost of maintenance instead of spending more money in purchasing of new equipment and increase output of passenger manifest with the interconnection more than one computer system over network. The motivation that led to the implementation of the proposed system is as a result of inefficiency will be notified and new system design implemented. With references to the rapid growth in the information technology, it is deemed necessary to develop a fully computerized system for the processing of visa in Nigeria airways service through this project.
The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. The study will minimize repetitive work done by the system administrator and reservation clerks and reduce effort and frustration for travelers in scheduling a trip, especially by reducing the search effort for the flight they need to take. The expected result is a Computerized Airline Reservation System that will verify and give accurate passenger airline seat reservation information through the use of an internet accessible device, and keep records of all immigrants and for processing visa with view of modifying it into a full computerized system.
CHAPTER ONE
1.1 Introduction
Airline Reservation Systems used to be a standalone system. Each airline had its own system, disconnected from other airlines or ticket agents, and usable only by a designated number of airline employees. An Airline Reservation Information System is a computerized system used to store and retrieve information and conduct transactions related to travel. Computer Manifest Information is classified as Passenger Service Systems (PSS) which handles a series of critical functions for the airline. For an Airline, the reservation system is a mission critical system that should use the latest state of the art technology to provide for all flight reservations on a robust platform, which is flexible and can be adapted to any style of airline. Secure and stable systems are vital to the airline industry which is why companies spend many years designing an architecture specifically suited to the nature of the airline industry which often requires tens of thousands of users to access and use the system simultaneously.
As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.
1.2 Background of Study
In science and technology, the desire for improvement is a constant subject which triggers advancements. This is visible in every ramification and the airline industry is not an exemption. 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. Today modern airline reservation systems are comprehensive suites of products to provide systems that assist with a variety of airline management tasks and service customer needs from the time of initial reservation through completion of the flight.
Sosoliso Airlines Limited was a scheduled, domestic, passenger airline. For much of its existence it had its head office in Ikeja, Lagos State (Sosoliso Airlines, 2009). It was established in 1994 and started operations in July 2000. The Nigerian government set a deadline of 30 April 2007 for all airlines operating in the country to re-capitalise or be grounded, in an effort to ensure better services and safety. Seven airlines failed to meet the deadline and as a result would not be allowed to fly in Nigeria's airspace with effect from 30 April 2007. These were: ADC Airlines, Fresh Air, Sosoliso Airlines, Albarka Air, Chrome Air Service, Dasab Airlines and Space World Airline. The affected airlines would only fly when they satisfied the Nigerian Civil Aviation Authority (NCAA)’s criteria in terms of re-capitalization and thus be re-registered for operation (Nigeria Direct, 2007).
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 by implementing an online reservation system this ensures that reservation are not only generated by the airline own staff but also by any travel agent using a Global Distribution system or other airlines that have a multilateral Interline Traffic Agreement with the airline.
1.3 Statement of Problem
The existing system is manual, this system is slow, time consuming and it is very difficult for each person to assess the Airline Reservation Information to verify an individual's airline transport ticket 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 very 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.
Finally, inability of the computer scientist to observe appropriate procedure in connection during installation poses treat to them, which however may lead to damage of the computer and cards
1.4 Aim and Objectives of the Study
The aim of the study is to Design and Implement a Computerized Airline Reservation System. In achieving this aim, the following specific objectives were laid out as follows to design and develop an application software that will:
- Keep records of all immigrants and for processing visa with view of modifying it into a full computerized system
- Verify and give accurate passenger airline seat reservation information through the use of an internet accessible device.
- Minimize cost of maintenance instead of spending more money in purchasing of new equipment, the money can be used in the maintenance of the faulty equipment.
- Reduce the number of manpower (staff) with the introduction of the computer network (computerized).
- Increase output of passenger manifest with the interconnection more than one computer system over network.
1.5 Significance of Study
From the viewpoint of the Computerized Airline Reservation System; 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.
- Reduce effort and frustration for travelers in scheduling a trip, especially by reducing the search effort for the flight they need to take.
This study will be of immense benefit to other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. This study contributes to knowledge and could serve as a guide for other study.
1.6 Scope of Study
The study focuses on the Design and Implementation of a Computerized Airline Reservation System using Sosoliso Airline in Enugu State as a case study.
1.7 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
- Research material: availability of research material is a major setback to the scope of the study.
- Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
- Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).
1.8 Definition of Terms
Computer Network: This is the process whereby two or more computers are connected so that they can communicate with each other at the same time. Share resources, file and other peripherals devices like scanner and printer.
Expert system: Is a computer program which solves problems from a specific knowledge base that is a body of knowledge in a specialized field.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Computerization of Airline Reservation System can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Framework
- 2.3 Types of Information System
- 2.3.1 Transaction Processing System (TPS)
- 2.3.2 Management Information System (MIS)
- 2.3.3 Decision Support Systems (DSS)
- 2.3.4 Executive Support System (ESS)
- 2.4 Application of Reservation Systems
- 2.5 Advantages of Passenger’s Seat Reservation Information Systems
- 2.6 Limitations of Passenger’s Seat Reservation Information System
- 2.7 Concept of System User Registration
- 2.7.1 Online System User Registration
- 2.7.2 Usage of Online Registration Forms
- 2.8 Manifest Information System Web Portal
- 2.8.1 Types of Web Portals
- 2.9 Database for Web Portals
- 2.9.1 Merits of Integrating Databases in Web Applications
- 2.10 Airline Reservation Information Systems
- 2.10.1 Components of Reservation Information Systems
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 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
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.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
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”
Disclaimer for Complete Material Utilization
The displayed research work titled "Computerization of Airline Reservation System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of Problem
- 1.4 Aim and Objectives of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the Study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Theoretical Framework
- 2.3 Types of Information System
- 2.3.1 Transaction Processing System (TPS)
- 2.3.2 Management Information System (MIS)
- 2.3.3 Decision Support Systems (DSS)
- 2.3.4 Executive Support System (ESS)
- 2.4 Application of Reservation Systems
- 2.5 Advantages of Passenger’s Seat Reservation Information Systems
- 2.6 Limitations of Passenger’s Seat Reservation Information System
- 2.7 Concept of System User Registration
- 2.7.1 Online System User Registration
- 2.7.2 Usage of Online Registration Forms
- 2.8 Manifest Information System Web Portal
- 2.8.1 Types of Web Portals
- 2.9 Database for Web Portals
- 2.9.1 Merits of Integrating Databases in Web Applications
- 2.10 Airline Reservation Information Systems
- 2.10.1 Components of Reservation Information Systems
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 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
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.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
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”
Disclaimer for Complete Material Utilization
The displayed research work titled "Computerization of Airline Reservation System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Can this topic “Web Based Nitel Telephone Billing System” be used for Computer Science (CS) Project?
Yes it can be utilized for research — NITEL Telephone billing system is a process of gathering consumption data, calculating billing and charging information, availing customer bills, processing the customer payments as well as managing collection of debts. The aim of the study is to design and implement a web based NITEL Telephone Billing System for effectiveness and ease of the problems facing the manual system. In achieving this aim, the following specific objectives were laid out to design and develop an application software that will identify the problems that are encountered in the manual telephone System, ensure accuracy in the daily telephone billing operations or activities and Detect sources of these errors and arrive at system that takes care of anomalies and give customers the best possible …
Can the material for “Financial Deregulation, Stock Price Volatility and Monetary Policy in Nigeria” be used as a guide for Accountancy / Accounting Project?
Yes it can be used — Germane to every monetary policy is the goal of achieving price stability. The objective of price stability essentially encapsulates the need to eliminate price expectations to zero and to eliminate the long run uncertainty about the price level. The trend is interesting and indeed focused within the purview of two monetary frameworks – inflation targeting and monetary targeting extremes. The Nigerian CBN has been on both sides of this divide. In between this divide is found the income targeting frameworks and the Friedman-type policy rule which itself has been criticized for reasons of perceived instability in the demand for real money balances by monetary targeting advocates. Consequently, the objective of this study is to determine whether inflation expectation and price volatility …
Can this topic “Impact of Population Growth on Unemployment in Nigeria; An Empirical Analysis” be used for Economics Project?
Yes it can be utilized for research — Economists overtime have attributed population explosion as one of the chief causes of unemployment in developing economies. This study examines the impact of population growth on unemployment rate in Nigeria between 1985 and 2015. The study adopted the econometric techniques of the unit root test, cointegration test, multivariate regression analysis and the pair-wise granger causality test for the analysis of data. The results revealed that population growth rate; per capita income and unemployment rate except total population became stationary at the first-order difference. It was also found that a long-run equilibrium relationship existed between population growth and unemployment. Furthermore, the regression result showed that population growth rate, total population and per capita income significantly and positively contributed to unemployment situation in …
Can this topic “Evaluation and Production of Enriched Fried Unripe Plantain Cake (Akara)” be used for Microbiology Project?
Yes it can be utilized for research — The study evaluates the Production process of Enriched Fried Unripe Plantain Cake (Akara). In achieving this aim, the following specific objectives were laid out to evaluate the produced enriched fried unripe plantain cake, prepare cakes from plantain composite flour blends, analyze the quality characteristics of the produced plantain cakes this included the physical, chemical and sensory properties of the product and evaluate the composition of cake produced from different ratios of plantain. Nutrient composition, organoleptic attributes and overall acceptability of plantain cake were evaluated. Plantain fingers in stages 2 (URP) and 5 of ripeness (RP) used in this study were washed, peeled, sliced into small pieces, sun-dried for five days and milled separately into flour. All the fried unripe plantain …
Can the material for “Knowledge, Attitude and Practice of Personal Hygiene Among Junior Secondary School Students” be used as a guide for Sex Education Project?
Yes it can be used — Personal Hygiene is fundamental to the prevention and control of communicable diseases and maintaining good health. The study was carried out to examine the Knowledge, Attitude and Practice of Personal Hygiene among Junior Secondary School Students at Irrua Girls Secondary School, Irrua, Edo State. In achieving this aim, the following specific objectives were laid out to assess the knowledge of Students of Irrua Girls Secondary School on personal hygiene and examine the practice of personal hygiene in the individual levels and to intervene them about personal hygiene. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A total of 120 (One hundred and twenty) respondents were selected …
Is the topic “Public Perception of Girl Child Education Among Rural Dwellers” recommended for Education Project?
Yes it is highly recommended — This study examined public perception of girl child education among rural dwellers in Laffia North L.G.A: Implications for social work practice. Data for the study were drawn using the questionnaire and in-depth interview. Data were analysed using the chi-square. Using a sample size of 521 (made up of 509 questionnaire respondents and 12 interviewees), findings of the study revealed that male respondents have negative views about educating a girl-child than female respondents; respondents with higher level of education have positive views on educating the girl-child; those with high income have positive view on educating their female children than those with low income; and, younger respondents have positive perception of girl-child education than older respondents. Based on these findings, the study …
Can the material for “A Sociolinguistic Study of Code-Mixing and Code-Switching in Nigerian Institutions” be used as a guide for Linguistics and Communication Project?
Yes it can be used — Code-switching is the use of more than one language, variety, or style by a speaker within an utterance or discourse, or between different interlocutors or situations. The study was carried out to Study the Socio-linguistic Effect of Code Switching and Code mixing in the Written English of Some Secondary School. In achieving this aim, the following specific objectives were laid out to conduct a sociolinguistic study on code-mixing and code-switching and examine ways can be used to avoid Code-Switching and Code-Mixing in learning English language. Investigation revealed that some of the studies focus on the way speakers of English code switch and mix between different language codes in their daily dialogues or conversations. All these studies drew their data from …
Can the material for “The Role of Small and Medium Scale Business as Means of Economic Development” be used as a guide for Education Project?
Yes it can be used — The work is an academic exercise which attempts to study the problems and prospects of small and medium scale enterprises in Nigeria. The researcher by undertaking this survey was able to unearth the contributions of small and medium scale business in changing a depressed economy. Research questions were formulated from which the major findings were obtained and recommendations were made. One of the findings is employment generation which is a major contribution of small and medium scale enterprises to any nation’s economy. It is therefore recommended that for small and medium scale enterprises to play its role in contributing to growth and development of the Nigeria economy, government should reform the educational systems to be more functional, relevant and need-oriented and …
Is the topic “Design and Implementation of a Computerized Transaction Processing and Reporting System for a Modern Supermarket” recommended for Computer Science (CS) Project?
Yes it is highly recommended — Modern supermarket is a day-to-day transaction that is carried out, with adequate reports and feedback on the status of the inventory and account. Transaction processing and report system is always very important to managements of the modern shops. The aim of the study is to design and implement a computerized transaction processing and reporting system for a modern supermarket. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will provide more effective, easy to use, cost affection accurate and comprehensive in report generation and monitor the activities of transaction processing and reporting system of Eastern shop. The motivation that led to the implementation of the proposed system is that the …
Can the material for “A Study of the Negative Impact of Technological Development on the Secretary in a Modern Office” be used as a guide for Office Technology and Management (OTM) Project?
Yes it can be used — A secretary is an office-staff who combines the mastery of secretarial skills of typewriting and shorthand with office routine functions. The study examined the Negative Impact of Technological Development on the Secretary in a Modern Office. In achieving this aim, the following specific objectives were laid out to examine the kind of modern technology that exists in the organizations, appraise the changes which technological advancement can cause in the duties of secretaries and recommend measures for blending the job of the secretary and sophisticated modern equipment in achieving high productivity in offices. The problem of this study is that many secretaries has been displaced in the office while many others have been hindered from securing a good job by the …