AIRLINE RESERVATION AND TICKETING IN A COMMERCIAL AIRLINE COMPANY
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 an Airline Reservation and Ticketing in a Commercial Airline Company. 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 an Airline Reservation and Ticketing in a Commercial Airline Company 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 Ticketing and Management 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 an Airline Reservation and Ticketing in a Commercial Airline Company. 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 Airline Reservation and Ticketing in a Commercial Airline Company; 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 an Airline Reservation and Ticketing in a Commercial Airline Company 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.
Installation: Installation is the process whereby a device, apparatus, or piece is fixed or fitted in a place to perform some specific functions.
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
Airline Reservation and Ticketing in a Commercial Airline Company 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 …
- ⋮
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”
Disclaimer for Complete Material Utilization
The displayed research work titled "Airline Reservation and Ticketing in a Commercial Airline Company" 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 …
- ⋮
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”
Disclaimer for Complete Material Utilization
The displayed research work titled "Airline Reservation and Ticketing in a Commercial Airline Company" 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)
Is the topic “The Impact of Parents Socio-Economic Status on the Academic Performance of Secondary School Biology Students” recommended for Biology Education Project?
Yes it is highly recommended — The study was carried out to examine the Impact of Parents Socio-Economic Status on the Academic Performance of Secondary School Biology Students. Investigation revealed that a significant portion of secondary school pupils continue to do badly in biology exams, according to data from testing organizations. Family's socioeconomic standing affects a student's academic achievement. But one cannot draw the inference that students from wealthy homes always perform better academically than students from low-income households. 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 two hundred (200) respondents were drawn from 10 selected secondary school in the study area. Data was collected using the questionnaire and analyzed …
Can the material for “Poverty and Electoral Violence in Nigeria” be used as a guide for Political Science Project?
Yes it can be used — The study was carried out to ascertain the effect of poverty and electoral violence in Nigeria with emphasis on Donga Local Government Area. Investigation revealed that diligence, efficiency, and hard work have all been hampered by election corruption. It has irreparably harmed Nigeria's political and social growth as well as the election process. It undermines a reliable voting process and makes it easier for an unpopular administration to take power. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. Primary data were collected from the primary source which questionnaire was used as an instrument of data collection while secondary data were sources from textbooks, journals, newspapers and …
Is the topic “Automated Contract Management Application Software” recommended for Management Project?
Yes it is highly recommended — The “Contract Management System” is concerned with the design of an information system for contract management that will efficiently handle the various activities in ministry of works Owerri. This covers all the information needed for managing any contract for the ministry. The aim of the study is to Design and Implement an Automated Contract Management System. In achieving this aim, the following specific objectives were laid out to design and develop a software that will: enhance front-end data capture, quicken the search for a particular information, improve file keeping and handing facilities, ensure the production of reliable time timely and accurate management information, and improve the handling of contract. The motivation that prompts the execution of the research work is …
Can the material for “Effects of the Nigerian English on the Academic Performance of University Students in Nigeria” be used as a guide for English Education Project?
Yes it can be used — The study was carried out to determine the Effects of the Nigerian English on the Academic Performance of University Students in Nigeria. In achieving this aim, the following specific objectives were laid out to determine the extent to which Nigerian English affect the academic performance of university students and investigate the factors enhancing Nigerian English amongst university students. 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 150 (one hundred and fifty) respondents were selected for this study to represent the entire population of the study. Primary data were collected from the primary source which questionnaire was used as an instrument of data collection while secondary …
Is the topic “The Physicochemical Properties of Honey” recommended for Biochemistry Project?
Yes it is highly recommended — Honey is a nutritious product that is produced by honey bees. Its composition depends highly on the type of flowers utilized by the bee as well as the climatic conditions. The purpose of the research work was to determine the quality of Nigerian honey in terms of physicochemical properties, and verify their compliance with international standards. The physicochemical property of the honeys [moisture, electrical conductivity, pH, HMF, acidity (free, total and lactones), reducing sugars, apparent sucrose, insoluble material, ash, and diastase activity] was determined. The moisture shows values of 14.21±0.18 % and 16.59±0.12%. The water insoluble material content ranged between 0.01 ± 0.03 to 0.67 ± 0.07%. The reducing sugars were between 66.3 ± 0.37 and 88 ± 0.23 %, …
Is the topic “Analysis of Financial Control System in Government Commercialized Enterprises” recommended for Public Administration (PA) Project?
Yes it is highly recommended — This research work analyses the financial control system in government enterprises in Nigeria. The National Electric Power Authority (NEPA) Enugu was chosen as a case study. The purpose of the study is to examine if there are financial control measures in NEPA Enugu, to see if these measures are adequate and in line with provisions of the regulations of the state and federal government, to determine if these measures are effectively applied and thus examine the implication of financial control NEPA Enugu. Twenty workers in the accounts department of NEPA, Enugu both district and zonal offices were chosen as the respondents of the study. Responses were collected from them with the use of questionnaire and oral interview were administered personally on them. The researcher …
Can the material for “The Effect of Language Interference on the Academic Performance of Secondary School Students” be used as a guide for Education Project?
Yes it can be used — Language Interference can be viewed as a transfer that affects learning both negatively and positively. It means that there is possibility for the learners to produce some mistakes or errors in learning a second language especially English. The aim of the study is to identify the effect of language interference on the academic performance of students in secondary school in Calabar South. In achieving this aim, the following specific objectives were laid out to examine the difficulties of language interference encountered by students in their academic performance, observe the differences when students speak another language outside their mother tongue, assess the level of linguistics is interference most noticeable among the secondary school students, and assess the transfer of their indigenous …
Is the topic “Risk in Supply Chain Logistics Constraints on Opportunity in Northern Eastern Nigeria” recommended for Purchasing and Supply (PS) Project?
Yes it is highly recommended — Supply chain management in any organization seeks to ensure that the goods materials are of the right quality, quantity, though at the right price and from the right source and made available for the organization in use at the right time. The study was carried out to examine the Risk in Supply Chain Logistics Constraints on Opportunity in Northern Eastern Nigeria using Limbot Express Logistics as a case study. In achieving this aim, the following specific objectives were laid out to evaluate the risk in supply chain logistics constraints on opportunity, determine the relationship between the risk management and supply chain logistics and investigate the risk factors inhibiting supply chain logistics in Northern Eastern Nigeria. Investigation revealed that most suppliers …
Is the topic “Arthritis and the Health of the Aged” recommended for Public Health Project?
Yes it is highly recommended — The study was conducted to assess the effect of Arthritis on the aged in Amakohia Community, Imo State. The study will employ a quantitative descriptive survey design, using a semi-structured questionnaire. The results also indicated that advanced age, insurance, regular smoking, diabetes, obesity, and osteoporosis were positively associated with Arthritis, while appropriate sleep duration, and insufficient vitamin A intake were negatively associated with Arthritis. Though cause and effect cannot be determined, modification of factors that are subject to change may help to reduce the risk of developing Arthritis. The level of practice and adoption of control measures along the elderly male population was significant. This shows that there is still a lot of work to be carried out as regards education, …
Can this topic “Bio-Metric Authentication of Voters and Voting Process” be used for Computer Science (CS) Project?
Yes it can be utilized for research — The elections that are made by using traditional methods are no longer preferred because of the long period of preparation, fake voting, faulty voting, mistakes made in counting the votes, long period of counting and high cost of voting process. In order to avoid these disadvantages affecting directly the economy and policy of the country, it is obligatory to carry the available voting system to an electronic system. Reacting to allegations of widespread voter impersonation (or “election rigging”, as commonly referred to in Nigeria) the Independent National Electoral Commission (INEC) attempted to conduct audits in several constituencies to determine the extent of multiple voting and voter impersonation. This should have been possible by comparing the fingerprints in the voters’ rolls …