Makerere University Business School: Developing A Tourism Management System For Prima Tours and Travel
Makerere University Business School: Developing A Tourism Management System For Prima Tours and Travel
SCHOOL
i
DECLARATION
We, the undersigned, declare that to the best of our knowledge, this proposal is our original piece
of work, and has never been published and/ or submitted for any award in any other University
or Higher Institution of Learning.
+256-753254979
Date:………………………………………………………
ii
APPROVAL
This proposal has been submitted with my approval as supervisor and my signature is here
appended:
iii
ABSTRACT
Most of the people in this world like to travel from one place to another no matter whether
it is a small or large distance. The need for a tourism management system that can manage
tourism information with ease is what Prima tours and Travel Company seek for. Tour
Management system is a dynamic website for tourism business. This travel and tourism
application is designed for Prima tours and Travel Company by which they can manage
different tour packages based on the destinations. By using this, the company can tailor
tour packages spanning various destinations at almost every price point. The implemented
search module also allows the administrator to find and update or upgrade the tour
packages with ease. This module can also even be extended to a customer application page
by which customers can find the right tour package for them at every budget, depending
on the tour locations. The main purpose is to help the company to manage tour packages
and also increase on the sales. The system can also be used for both professional and
business trips. The proposed system maintains a centralized repository to make necessary
travel arrangements and to retrieve information easily.
iv
ACRONYMS
v
Contents
DECLARATION..............................................................................................................................................ii
APPROVAL...................................................................................................................................................iii
ABSTRACT...................................................................................................................................................iv
CHAPTER ONE..............................................................................................................................................1
1.0 INTRODUCTION.....................................................................................................................................1
1.1 Background of the study....................................................................................................................1
1.2 Problem Statement............................................................................................................................2
1.3 General Objective..............................................................................................................................3
1.4 Specific Objectives.............................................................................................................................3
1.5 Study Scope.......................................................................................................................................3
1.5.1 Subject Scope..............................................................................................................................3
1.5.2 Geographical Scope....................................................................................................................4
1.5.3 Time Scope.................................................................................................................................4
1.6 Significance of Study..........................................................................................................................4
CHAPTER TWO.............................................................................................................................................5
LITERATURE REVIEW....................................................................................................................................5
2.0 Background studies of Previous Registration systems.......................................................................5
2.1 The Application of Intelligent Tourism Mobile Client Based On Ontology.........................................5
2.2 Destination Information Management System for Tourists...............................................................5
2.3 Role of Information systems in an Institution....................................................................................6
2.4 EXISTING SYSTEM..............................................................................................................................6
2.5 PROPOSED SYSTEM............................................................................................................................6
2.5.1 Advantages of the Proposed System...................................................................................7
2.5.2 EXPECTED OUTCOME OF THE PROJECT......................................................................................7
CHAPTER THREE..........................................................................................................................................8
3.0 RESEARCH METHODOLOGY...................................................................................................................8
3.1 Research Approach............................................................................................................................8
3.2 Study Population...............................................................................................................................8
3.3 Sources of Data..................................................................................................................................9
vi
3.4 Data Collection Techniques...............................................................................................................9
3.5 System Analysis and Design...............................................................................................................9
3.6 System Design Approach...................................................................................................................9
3.7 OBJECTIVE..........................................................................................................................................9
CHAPTER FOUR..........................................................................................................................................11
SYSTEMS ANALYSIS AND DESIGN...............................................................................................................11
4.0 Introduction.....................................................................................................................................11
4.1 Feasibility study...............................................................................................................................11
4.2 Systems Requirements....................................................................................................................13
4.2.1 FUNCTIONAL AND NON-FUNCTIONAL REQUIREMENTS...........................................................13
4.2.2 User Requirements...................................................................................................................13
4.2.3 System Requirements...............................................................................................................14
TECHNOLOGY USED...............................................................................................................................14
SOFTWARE REQUIREMENTS..................................................................................................................14
HARDWARE REQUIREMENTS.................................................................................................................14
4.2.4 MODULE...................................................................................................................................14
4.3 Design Approach..............................................................................................................................16
4.4 System development Method.........................................................................................................16
4.5 System Interface..............................................................................................................................16
4.6 System design..................................................................................................................................16
4.6.1 LOGICAL DESIGN.......................................................................................................................16
4.2.2 CONCEPTUAL DESIGN...............................................................................................................17
4.2.3 PHYSICAL DESIGN......................................................................................................................17
4.6 System Modeling.............................................................................................................................17
`4.6.1 Entity Relationship Diagram....................................................................................................18
4.6.2 Use-Case Analysis (admin)........................................................................................................19
4.6.3 Use Case Diagram for User.......................................................................................................20
CHAPTER FIVE............................................................................................................................................21
SYSTEMS DEVELOPMENT AND PRESENTATION.........................................................................................21
5.0 Introduction.....................................................................................................................................21
5.1 Systems Development.....................................................................................................................21
5.2 Systems presentation......................................................................................................................21
vii
CHAPTER SIX..............................................................................................................................................23
SUMMARY.................................................................................................................................................23
6.0 Introduction.....................................................................................................................................23
6.1 Conclusions......................................................................................................................................23
6.2 Limitations of the study...................................................................................................................23
6.3 Future scope....................................................................................................................................24
REFERENCES..............................................................................................................................................25
APPENDIX..................................................................................................................................................26
viii
CHAPTER ONE
1.0 INTRODUCTION
This chapter contains an introduction, background to the study, problem statement, and
objectives of the project, the study scope, and justification for the project
Mathieson and Wall (1982) define tourism as follows- "The temporary movement of people to
destinations outside their usual places of work and residence, the activities undertaken during
their stay in those destinations, and the facilities created to cater to their needs"
Years ago, the African Union and the African Union Development Agency adopted the Tourism
Action Plan to bring visibility to tourism on the continent. This came after a 300-percent increase
in international arrivals I the 1990s, reaching 26.2 million arrivals in 2000. Tourism has since
become integral to economic development policies. African countries like Gambia, Kenya, South
Africa and Tanzania recently increased efforts in their travel and tourism industries to
accommodate the nearly 62 million annual visitors to the continent. South Africa and Kenya
receive the largest amounts of tourism focused investment at $6.1 billion and $404 million
respectively. On national level, tourism has tremendously gown in Uganda over the last decade
1
with the improvement in security in the Northern part of the country, and huge infrastructure
investments from private and government. Uganda’s tourism industry created 321,960 jobs in
2020, the wages of skilled and unskilled labor were employed due to foreign tourist demand for
local goods and services, directly impacting household welfare. Today, Uganda does not lack
accessible travel highlights nor tourist facilities as the case was ten years ago, trunk roads have
improved beyond recognition with extremely friendly hosts to welcome the tourists
The rationale for using a tourism and travel system for Prima Tours and Travel is that the system
influences tourists’ perceptions and impressions which significantly determine their plan to visit
a destination therefore to make this effective; all travel and tourism information should clearly be
provided on the website. Online presence will provide credibility for the company, nowadays
people are tired of researching, if one needs a service, they just search on the internet, and so if
the company has a website, it acts as the face of the business in the digital world.
2
experience and mark their reviews on the website which helps other customers to make a perfect
decision, availability of the search option which allows users to fully explore, tour booking
services among others. With these, the company will be able to have an easier management of its
activities compared to operating on social media and phone call bookings alone.
1. To study and analyze the current system and criteria used by Prima tours and Travel
company in its daily operations
2. To develop and implement a tourism management system for Prima tours and Travel
company
3. To provide tourists with accurate information on tourist attractions to make more
informed decisions.
4. To develop and implement a credible and user-friendly system.
5. To develop a tourism management system that is web-based.
6. To assess the system’s acceptability, efficacy, timeliness, quality, and productivity from
the perspective of every individual.
3
1.5.2 Geographical Scope
The research report focused on Kampala District as the area of study. The majorities of people in
Kampala are travel oriented and are familiar with using the internet. This can enable them to
access the Tourism Management System using their computers and mobile devices.
The following persons or groups will benefit from the project’s success:
End-user (Tourists). The tourism management system will make it easier for users to find all of
the information they need about places and tours in one suitable place. Tourists will be able to
make appropriate decisions by visiting the tourism management system website, providing
details on tourist destinations.
Prim tours and travel company. In every travel agency, the system allows for better
management of tourists or customers. It will play a significant role in reducing the time it takes
to respond to inquiries and make bookings and poor customer service and feedback.
Researchers. The experience with the development and implementation of the project will
further improve the researcher’s knowledge and skills.
Future Researchers. If they choose to create and implement their own Tourism Management
System, they can use the study as a guide.
4
CHAPTER TWO
LITERATURE REVIEW
This section reviewed literature from closely related studies that have been carried out by other
researchers from their written articles, books, journals and reports on Tourism systems and any
other knowledge in line with the study topic. The section contains an overview of current
systems used, user requirements for mobile systems, design-based research in system
development, system testing and related information.
6
date of arriving, date of departure, food to be served and every single detail will be available to
the client. They just need once to click using mouse and everything is made available to them
7
CHAPTER THREE
The team preferred this approach because it would help achieve and understand a problem
domain through the building and application of a design artifact. In this research approach, the
team developed a Tourism Management System by identifying organizational and user
requirements, thus defining a practical solution to the current problem in the organization. The
team then designed logical models of a Tourism Management System that would be used at
Prima tours and Travel Company.
8
3.3 Sources of Data
The team collected primary data through; observation, interviews, questionnaires, and
organizational documents. Secondary data was gathered from published articles, reports,
journals, books and other online literature.
3.7 OBJECTIVE
This software is highly programmed in SQL technology in order to provide the best services to
customers and various travelling agents in the field of tourisms activities such as bookings,
accommodations, food services, tourism spot details and many more. This integrated software
offers one of the best ways of managing all the travel related businesses.
This software is designed in Word Press editor with SQL Server as backend and PHP language.
All the data will be stored in the server and in case of any data losing situation, a backup will be
available by this server. The software is being designed in such a way that all the details related
to every aspect of tourism will be available separately and the customers and agents will not have
9
to go through any of the problem. They just have to click once and all the details will get
available to them.
10
CHAPTER FOUR
4.0 Introduction
This chapter presents system analysis and design for implementation of a Tourism Management
System. The study analysed the current system used, requirements for the new system, design
approach, development method, system interface and system modelling. These were based on
information obtained from observation, interviews and questionnaires that were used in data
collection.
Technical Feasibility
The technical issue usually raised during the feasibility stage of the investigation includes the
following:
Economic feasibility
11
A system can be developed technically and that will be used if installed must still be a good
investment for the organization. In the economic feasibility, the development cost in creating the
system is evaluated against the ultimate benefit derived from the new systems. Financial benefits
must equal or exceed the costs. The system is economically feasible. It does not require any
additional hardware or software.
Operational feasibility
Proposed projects are beneficial only if they can be turned out into information systems, which
will meet the organization’s operating requirements. Operational feasibility aspects of the project
are to be taken as an important part of the project implementation. Some of the important issues
raised are to test the operational feasibility of a project includes the following:
This system is targeted to be in accordance with the above-mentioned issues. Beforehand, the
management issues and user requirements have been taken into consideration. So there is no
question of resistance from the users that can undermine the possible application benefits. The
well-planned design would ensure the optimal utilization of the computer resources and would
help in the improvement of performance status.
Technical feasibility
There are different technologies on the market and internet for implementation of the system.
These includes but not limited to; Android studio, Google map, MySQL, Java, Kotlin, Php and
search engines like Google chrome and many others. Those technologies were freely available
on internet thus the proposed system could be built.
Time feasibility
12
The project was scheduled to be completed in two months, given the commitment, collaboration
and communication from project team, the system was to be implemented in agreed and
scheduled time.
The system should have security controls where the user’s information is protected and kept
confidential from unauthorised users like hackers through the use of strong passwords.
13
It should be able to identify the available destinations to the user.
The system should be able to show the user the fares for the different services offered
The user should be able to access his/her registration information from the system using the
mobile phone.
It should enable users to view the progress of their booking status by use of a phone or computer.
TECHNOLOGY USED
Word Press
SQL server
PHP
SOFTWARE REQUIREMENTS
Windows
Word Press
HARDWARE REQUIREMENTS
Laptop
Router
Paper
4.2.4 MODULE
After careful analysis the system has been identified to have the following modules:
1. Administrator module
2. User(Traveler) module
3. Guest user
14
ADMINISTRATOR MODULE: This module provides administrator related functionality.
Administrator manages all information and has access rights to add, delete, edit and view the
data related to places, travels, routes, bookings, Enquiries etc.
Packages—Admin will create the packages and Manage the packages (Create, Update,
delete)
Booking- Admin will responsible for manage booking. Admin can confirm and cancel a
booking of traveler.
Manage issues/ Complaints—Admin can take action on any issue /complaint raised by user
(traveler) and Put remarks.
Manage pages- Admin can edit the info of all pages that are display on the website,
Dashboard- Here admin can view all count of booking, issues, Enquiries and Users.
Sign in- Here user can login with valid username and password.
My Profile- user can update own profile. Tour history-After login user can book any tour
that will show in Tour history. User can cancel his/her booking before 24 hr. of travelling.
15
GUEST MODULE: Guest user can visit the website and view the all content of website.
Guest users can also Enquiry.
i. Logical design
ii. Conceptual design
iii. Physical design
16
4.2.2 CONCEPTUAL DESIGN
This was just a description of the proposed system in terms of a set of integrated ideas and
concepts about what the system is expected to do, behave and look like, that would easily be
comprehended by the users in the manner intended. This process was started by identifying
several entities required by the users and also identifying all the important relationships that exist
between the entities. The result was the model of the user interface that has been developed.
17
`4.6.1 Entity Relationship Diagram
18
4.6.2 Use-Case Analysis (admin)
19
4.6.3 Use Case Diagram for User
20
CHAPTER FIVE
5.0 Introduction
In this chapter documents how the conceptual and logical designs of the TMS was implemented.
It shows how the different user interfaces were developed and inter linked using different
programming languages.
PHP: PHP (recursive acronym for PHP: Hypertext preprocessor) is a widely-used open source
general-purpose scripting language that is especially suited for web development and can be
embedded into HTML.
21
Review page
This page enables the users to review the services being offered the company.
About page
22
This page shows the descriptions of the company i.e users can find out the company
Services page; This page shows the services being offered by Prima tours and travel company
23
Destination Page; This page display different destination where a user can choose to his interest
24
CHAPTER SIX
SUMMARY
6.0 Introduction
Under this chapter, the researcher presents the discussions of the study, conclusions and
recommendations the research team has about the finding and the interpretations from the
analysis.
6.1 Conclusions
The project, developed using PHP and SQL is based on the requirement specification of the user
and the analysis of the existing system, with flexibility for future enhancement. Tourism is
currently recognized as a worldwide industry which is very growing at a high rate like other
industry. There are many various activities are occurred in tour activities. My ‘Tourism
Management System’ web-based application helps in online distribution of tour packages, hotel,
hotel properties, transportation etc. This ‘Tourism & Travel Management System’ are often fully
customized with integration different API’s. It’s friendly environment that connects customer
willingly. It’ll help both the customers and Prima tours and travel company to supply the
facilities with more categories. It’ll save time and reduce paperwork. No chance of losing any
kind of data during the transaction. The system will accompany more upgrades and a
replacement feature within the future. It’ll be more upgraded with its web interface layout.
Finally, I can say that this Web Based Application will help company manager to regulate and
handle the tour related activates effectively and efficiently. Therefore, it can be deducted that
research project was to a greater extent successful, as the research team was able to analyse the
current system, collect and analysed data for the new system, design and implemented the
system.
25
6.3 Future scope
A plenty of difficulties has come in front of me during the research period. To resolve that
drawbacks, some studies can be conducted in the future. The scope of the future works of the
system is given below:
The system is made here to ensure that tourists could adapt to the upcoming competitive
world. Here all the facilities are made and tested.
In future, the system will be extended for many types of features so that efficiency can be
improved.
The features of the website can be changed according to user demand.
It can be possible to add some more features or remove some features which are not
useful for the user.
This web application will be converted to android application
26
REFERENCES
1. Abdul Hamid S.M. &Gana U. (2010). Destination Information Management System For Tourist:
Computer Science and Telecommunications. Georgian Electronic scientific journal, vol 6(issue
29).
2. Adebayo, W. J. (2014). The Economic Impact of Tourism Development. Journal of Tourism,
Hospitality and Sports, Vol.2.
3. Adora, C. U. (2010). Managing Tourism in Nigeria. Management Science And Engineering, Vol.
4(1), pp. 14-25. American Scientific Research Journal for Engineering, Technology, and Sciences
(ASRJETS) (2016) Volume 18, No 1, pp 304-315 315
4. Anastasia A., Panagiota D. &Georgios M. (2012). A Web-based Prototype System For
Personalized Tourism Destination Discovery And Management. Technological Educational
Institute of Athens, Athens.
5. Daramola, J. O. (2009). A Software Product Line Approach To Ontology-Based Recommendations
In E-Tourism Systems. School Project, Convenant University, Computer And Information Science.
6. Heum P., Aesun Y. &Hyuk-Chul K. (2012). Task Model and Task Ontology for Intelligent Tourist
Information Service. International Journal of u- and e- Service, Science and Technology, Vol.
5(Issue 2).
7. Zhou F, Zhao M, Sun Z, Zhao J & Gong Z. (2014). The application of intelligence tourism mobile
client based on ontology. Journal of Chemical and Pharmaceutical Research, Vol. 6(Isssue 5), pp
258- 265.
8. Sommerville, I. (2006). Software Engineering (Vol. 8). Addison-Wesley.
9. Robert V. S (2004). Object-Oriented System Analysis And Design With UML.
10. Thomas C. B. (2005). Database Systems; A Practical guide to Design, Implementation, And
Management (Vol. 4). (A. McGettrick, Ed.)
11. Oludele A., Onuiri E., Olaore O., Sowunmi O. &Ugo-Ezeaba A. (2015). A Real-Time Crime Record
Management System For National Security Agencies. European Journal Of Computer Science
And Information Technology, Vol. 3(2), pp. 1-12
27
APPENDIX
Budget
28
Gantt chart
29