ABSTRACT
This project is aimed at designing an Online Tourism Management System (Case Study of Niger State Tourism Corporation). Tourism is very important to the growth of every Nation’s economy. There is an existing manual tourism management system in use, which handles the management of the activities in the tourism corporation, but this system is affected by a couple of problems such as: slow response to bookings and inquiries, poorly detailed records, few number of attendants delivering information and services to clients. The world has become a global street, hence the need for computer systems in almost every field of human endeavours. A computerized tourism management system has therefore been designed to help solve the above mentioned predicaments. The proposed new system is designed and implemented using data collected from interviews with members of the tourism corporation, and the general public. After implementation and testing, the system efficiently solved the problems faced by the manual system used in the Niger State Tourism Corporation. The following scripting languages MySQL, HTML, JavaScript and PHP were used to design the system.
TABLE OF CONTENT
Â
COVER PAGEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â i
ABSTRACTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ii
TABLE OF CONTENTÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â iii
LIST OF TABLESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â vi
LIST OF FIGURESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â vii
Â
CHAPTER ONE: INTRODUCTION
1.1      Background to the Study                                                                                         1
1.2      Statement of the Problem                                                                                          4
1.3      Aim and Objectives of study                                                                                    4
1.4      Significance of study                                                                                                  5
1.5      Scope of study                                                                                                                        5
1.6      Limitations of Study                                                                                                  6
1.7      Operational Definition of Terms                                                                                 6
CHAPTER TWO: LITERATURE REVIEW
2.0     Introduction                                                                                                                 8
2.1    Overview of Tourism                                                                                                  8
2.1.1   Importance                                                                                                       10
2.1.2   Problems of Tourism                                                                                       10
2.1.3   The role of Tourism in National Development                                               11
2.2     Tourism in Niger State                                                                                              12
2.3      Review of Related Work                                                                                        14     2.3.1      Types of Tourists                                                                                           15
2.4    Information System                                                                                                   16
2.4.1   Information System Components                                                                   17
2.4.2   Categories of Information System                                                                  18
Â
Â
CHAPTER THREE: SYSTEM ANALYSIS AND DESIGN
3.0    Introduction                                                                                                                 19
3.1    Analysis of the Existing System                                                                                   20
3.1.1 Existing Manual System                                                                                  20
3.1.2 Existing Tourism Websites                                                                              21
3.2     Limitations of the existing system                   `                                                           23
3.3      Justifications of the New System                                                                                24
3.4      Methodology                                                                                                               25
3.5       Data Collection                                                                                                          29
3.6      The Proposed New System                                                                                          30
3.6.1 Input Design                                                                                                      30
3.6.2 Storage Design                                                                                                  33                3.6.3 Output Design                                                                                               33
CHAPTER FOUR: SYSTEM IMPLEMENTATION, TESTING AND INTEGRATION
4.0     Introduction                                                                                                                 34
4.1     Choice of programming Language                                                                              34
4.2      The System main menu Implementation                                                                     37
4.3     Implementation of the Subsystem                                                                               37
4.4       Query Subsystem Implementation                                                                           39
4.5      System Testing and Integration                                                                                  43
Â
CHAPTER FIVE: SUMMARY AND CONCLUSION
5.0      Introduction                                                                                                                45
5.1      Summary                                                                                                                    45
5.2     Findings and Discussion                                                                                            46
5.3     Suggestion for Further work                                                                                      46
5.4      Recommendation                                                                                                       46
5.5     Conclusion                                                                                                                 47
Â
REFERENCESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 48
APPENDIXÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 50
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
LIST OF TABLESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â PAGE NO
Table 3.1: Manual Tourism Booking Form                                                                           21
Table 3.2: Statistics of people interviewed                                                                            26
Table 3.3: Database capture of the data collected from users                                                            29
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
LIST OF FIGURESÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â PAGE NO
Â
Figure 2.1 Components of Information System                                                                     18
Figure 2.2 Categories of Information System                                                                        18
Figure 3.1 Home page of existing tourism information website                                             22
Figure 3.2 A section of existing tourism website                                                                  22
Figure 3.3 Error page found on website                                                                                 23
Figure 3.4 Statistical Pie chart representation                                                                       26
Figure 3.5 Use Case diagram of the proposed system                                                           28
Figure 3.6 Administrator Section Flowchart                                                                         31
Figure 3.7 User Section Flowchart                                                                                      32
Figure 3.8 System Output Design                                                                                         33
Figure 4.1 System main menu page implementation                                                              37
Figure 4.2 Sign in page implementation                                                                                37
Figure 4.3 Admin task management implementation                                                             38
Figure 4.4 Admin information update                                                                                   39
Figure 4.5 User create account implementation                                                                     40
Figure 4.6 Existing user sign in page                                                                                    40
Figure 4.7 Home page upon user log in                                                                                41
Figure 4.8 Log in error page                                                                                                 41
Figure 4.9 Tourist Booking Form                                                                                        42
Figure 4.9.1 Booking Receipt                                                                                                 43
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
Â
CHAPTER ONE
INTRODUCTION
1.1 BACKGROUND OF STUDY
Tourism is the travel for recreation, leisure, religious, family business purposes, usually of a limited duration. Tourism is considered an activity essential to Nations because of its direct effects on social, cultural, educational and economic sectors of National societies and their International relations.
According to the third edition of the Oxford English dictionary, tourism is defined as the commercial organization and operation of holidays and visits to place of interest.
Tourism can be defined as a short-term movement of people to places some distance away from their normal place of residence to indulge in pleasurable activities. (Swarbrook and Horner, 2007).
When a person leaves his home town for another location in the same country, he is termed a Domestic tourist. But if he crosses the frontiers of his country, he then becomes an International tourist. The people who visit Minna in December to attend the Akpazuma festival are domestic tourists while those who come from other countries to visit the Gurara water falls, are International tourists.
However, tourism is fast becoming one of the most functional industries in the world. It makes great impact in Nations by helping to create employment opportunities, by developing infrastructures, and a very rich source of income and revenue.
It plays an important role by offering employment to a good number of a Nation’s population that could be doctors, dancers, engineers, labourers, entertainers etc. For instance, in places like Britain over three million people are engaged in tourism, also in Spain and Italy, the figures are higher than seventy percent respectively. This explains why both countries are world leaders in the tourism industry. Nigeria has a huge number of parks, holiday resorts, and hotels. It is estimated that the Nigerian tourism industry can employ a hundred thousand people. By doing this, the large number of unemployed people would be removed from idleness and joblessness.
Tourism helps improve a nation’s infrastructural development. It provides amenities such as good transport and communication network, cheap and comfortable accommodations, essential infrastructures and super structures. As a result of this, tourism has been integrated into the national plans of many countries to raise the economic standard of physical of their environments and improve the people’s social interaction. Tourism also creates a considerable impact on the improvement of the general features of the environment, the establishment of hotels and allied industries. It also provides benefits that come in the form of provision of necessary infrastructure, provision of electricity, the construction of roads, and portable water supply and sewage disposal system.
As a rich source of income and revenue; tourism has become one of the most integral source of foreign exchange and balance of payments to many tourism inclined countries. This can be exemplified by Britain whose greatest exports includes tourism which is one of the fastest growing items of International trade.
Besides being a source of foreign exchange earnings, tourism could also assist in promoting national unity and mutual understanding through domestic and international travels. If tourism is properly groomed in Nigeria, it will breed peace and unity and many Nigerians will have the opportunity to visit different other states and tribes. This will eliminate conflicts, and reduce tribalism and religious tensions.
Thus, promotes the spirit of oneness and love among citizens of various nations, creates and build a good relationship and united society.
Very importantly, it draws our minds back to our origin from the rapid western civilization and helps preserve the culture and heritage of people.
The preservation and enhancement of the tradition, and native handcraft helps to create distinct local tourism products and this in turn gives way for promotion and awareness of the Nation’s heritage.
Nigeria has great tourism potentials. The awareness and understanding of tourism in the private sector shows that with a well-organized tourism private sector participation, and government realizations of tourism, tourism activities could generate employment, upliftment of social life in rural areas and the government will see reasons to provide the much needed tourist infrastructures for the growth of tourism in our country.
Nigeria is truly endowed with beautiful natural resources relative to other Nations in Africa and even on a global level. These natural resources include; peculiar geomorphologic features, water bodies, wild life and game reserves.
The application and use of computers in various facets of human activities cannot be over emphasized. Since the introduction of the microcomputers in the 1970’s and 1980’s, the world of office automation has continued to evolve with modernization made to the present ones.
Some may wonder why there is a need for a computerized tourism information system. This is because;
- The world has become a global street. Day by day people engage in more activities on the internet, it is only fair to use the internet facility to make tourism activities more accessible and informative.
- If properly designed and implemented, an online tourism system would be more organized, and efficient than a manual filing system.
- It can also be used to complement the manual system; it can serve as a backup for all information in the files, thereby keeping them safer in the cloud.
Â
1.2Â Â Â Â Â Â STATEMENT OF THE PROBLEM
This project is embarked on to solve the following problems:
- Delay in handling enquiries and making bookings, poor customer service and feedback.
- Unauthorized access to vital documents and files of the corporation, and displacements of records.
- Certain tourist locations and accommodations may be unavailable at certain times and the existing system may fail to communicate these to a customer as a result of unorganized information which may put customers in cases of unplanned expenses or an uncomfortable tour.
The major problems experienced is the poor information flow, delay in handling enquiries, making bookings, and poor customer service and feedback.
These problems make it difficult for customers to book their tour because the current system is inefficient.
Hence, an efficient system is required to eliminate such problems after a structural analysis of the existing system.
Â
1.3Â Â Â Â Â Â AIM AND OBJECTIVES
The aim of this study is to develop an interactive website that helps potential visitors get enough information about the various destinations in Niger state that may ease their tour. It has the following objectives:
- To explore the problems encountered in the management of the existing manual tourism system
- To design a web based system that will make information more detailed, effective, and accurate, and ease the delay hitherto encountered with the existing manual system.
- To implement a web based tourism system that will help people appreciate the state’s natural endowment and also serve as a complementary tool for tourism management.
Â
1.4Â Â Â Â Â Â SIGNIFICANCE OF THE STUDY
This study would to a large extent, provide very useful output for a more effective operation of the tourism destinations in Niger state as a whole, it will also complement the efforts of the managers of these tourist centres by, helping them make more accurate judgments and also by providing detailed information accurately to the public for strategic and profitable achievements of the centres.
This research provides an awareness of the problem and prospects of tourism in Niger state to the general public, which will broaden their knowledge, understanding and help them understand the importance of tourism.
The government also has its benefits as the study appraises various governmental guidelines and offers some suggestions for more efficient operations of these resorts.
In summary, this project work will provide a solution to the subject of tourism management, an alternative to the existing manual system and will be readily available to anyone with a device that has a functional browser and access to the internet.
1.5Â Â Â Â Â Â SCOPE OF THE STUDY
The scope of this research, design and development dwells only on Minna metropolis and a few prominent tourist destinations surrounding it. This is because, tourism is a broad topic and due to research time restriction, lack of needed research materials and resources, the scope of the study is limited.
Â
Â
1.6Â Â Â Â Â Â LIMITATION OF THE STUDY
In the cause of accomplishing these tasks, obstacles were encountered. Due to the wide scope and discovery of new tourist destinations in the state, it makes it intricate to have the background knowledge of these destinations and most importantly, areas needed for data collection of this study were inaccessible either for security reasons or otherwise. As a result of that, limited source of information was gathered.
Hence this study focuses only on six (8) tourist destinations for this project.
Even with the above constraints, I endeavoured to gather adequate information within my capability to carry out this study accurately so as to ensure objective and meaningful deductions.
1.7Â Â Â Â Â Â OPERATION DEFINITION OF TERMS
- Tourism: The business of providing places for people to visit and activities for them to do.
- Tour: Touring process means to visit different environments,
- Tourist: A person who travels or visits different places for pleasure or other reasons.
- Domestic tourist: A person who leaves his home for another town in the same country
- International tourist: A person who leaves his country to visit another country
- Systems: A set of things working together as a whole to achieve the same sole objective.
- Design: A plan made to show the function of a particular project before it is made. It can be referred to as a prototype of a product or system.
- Program: A set of instructions that directs a computer on how to perform particular tasks.
- Database: A set of data or information stored in a computer system that is accessible in many ways.
- File: A collection of related records.
- Information system: A system composed of different components that processes or interprets tourism information.
- Booking system: The process of making arrangement so that a space in a hotel, or a particular period which you want to use for touring, is reserved for you.
- Booking form: The form which user inputs details needed to make a reservation
- Booking receipt: The document which shows that user has successfully made a reservation.
- Web browser: It is a software application for retrieving, presenting information resources on the World Wide Web.
- URI: The uniform resource identifier, identifies an information resource.
- URL: The uniform resource locator is also known as the web address.
- Web based information system: It is an information system that uses Internet web technologies to deliver information and services to users or other information systems.
- Check IN: This is the process of reporting one’s arrival at a place.
- Check OUT: This process depicts one’s departure from a place.
Â
This material content is developed to serve as a GUIDE for students to conduct academic research
AN ONLINE TOURISM MANAGEMENT SYSTEM AT FEDERAL UNIVERSITY OF TECHNOLOGY, MINNA.>
PROJECTOPICS.com Support Team Are Always (24/7) Online To Help You With Your Project
Chat Us on WhatsApp » 07035244445
DO YOU NEED CLARIFICATION? CALL OUR HELP DESK:
07035244445 (Country Code: +234)YOU CAN REACH OUR SUPPORT TEAM VIA MAIL: [email protected]