Tourism Database Management System Using Data Warehouse Approach
ABSTRACT
Tourism as being a great source of revenue in so many countries like Britain, Australia, Malaysia
and many other countries. Seeing the viability of the sector in these countries where tourism as
served as one of the life wire of the country economy, has stirred other country government to
invest vastly in the sector. The tourism sector of the above named countries has served as a
source of employment for the citizenry in various capacity.
In reflection of the above statement, this thesis will be centric on the proposal for developing a
tourism database management system using warehouse approach for the Nigeria government.
The system will be developed basically to give reports related to the tourism sector.
TABLE OF CONTENTS
CHAPTER ONE: INTRODUCTION…………………………………………………………………………………………..12
1.1 INTRODUCTION…………………………………………………………………………………………………………… 12
1.2 AIM………………………………………………………………………………………………………………………………. 13
1.3 OBJECTIVES………………………………………………………………………………………………………………….13
1.4 PROBLEM STATEMENT………………………………………………………………………………………………..14
1.5 SCOPE………………………………………………………………………………………………………………………….. 14
CHAPTER TWO: LITERATURE REVIEW………………………………………………………………………………..15
2.1 INTRODUCTION…………………………………………………………………………………………………………… 15
2.2 BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA………………………………..16
2.3 THREE TIER DATA WAREHOUSE…………………………………………………………………………………….17
2.3.1 BOTTOM TIER……………………………………………………………………………………………………………18
2.3.2 MIDDLE TIER……………………………………………………………………………………………………………..18
2.3.3 TOP TIER…………………………………………………………………………………………………………………….19
2.4 THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM………………………………………….19
2.4.1 CHARACTERISTICS OF DATA WAREHOUSE…………………………………………………………….19
2.4.1.1 SUBJECT ORIENTED WITH………………………………………………………………………………….19
2.4.1.2 UNIFIED:………………………………………………………………………………………………………………19
2.4.1.3 TIME VARIATION………………………………………………………………………………………………..20
2.4.1.4 NONVOLATILE:……………………………………………………………………………………………………20
2.5 CLOUD COMPUTING………………………………………………………………………………………………………..20
2.6 BIG DATA COMPUTING……………………………………………………………………………………………………21
2.7 DATA WAREHOUSE IN EGYPTIAN TOURISM………………………………………………………………….22
2.7.1 ANALYSIS OF DATA SOURCES………………………………………………………………………………….22
2.8 DATA WAREHOUSE IN CHINA TOURISM………………………………………………………………………..23
2.9 DATA WAREHOUSE IN ROMANIAN TOURISM………………………………………………………………..24
CHAPTER THREE: REVIEW OF TECHNOLOGIES…………………………………………………………………..26
3.1 INTRODUCTION………………………………………………………………………………………………………………. 26
3.2 Oracle Database 11g…………………………………………………………………………………………………………….26
3.2.1 ORACLE APPLICATION EXPRESS………………………………………………………………………………27
3.2.2 INTERACTIVE REPORT………………………………………………………………………………………………29
3.2.3 FLASH CHARTS………………………………………………………………………………………………………….31
7
3.2.4 DYNAMIC ACTION……………………………………………………………………………………………………. 32
3.2.5 TRIGGER…………………………………………………………………………………………………………………….32
3.3 ETL (EXTRACTION, TRANSFORMATION AND LOADING)………………………………………………33
3.4 CONCLUSION…………………………………………………………………………………………………………………..34
CHAPTER FOUR: PROPOSED METHODOLOGY……………………………………………………………………..35
4.1 SYSTEM METHODOLOGY………………………………………………………………………………………………..35
4.1.1 REQUIREMENTS PLANNING PHASE………………………………………………………………………….36
4.1.1.1 PROPOSED SYSTEM REQUIREMENTS…………………………………………………………………37
4.1.2 USER DESIGN PHASE…………………………………………………………………………………………………38
4.1.3 CONSTRUCTION PHASE…………………………………………………………………………………………….38
4.1.4 IMPLEMENTATION PHASE………………………………………………………………………………………..38
CHAPTER FIVE: PRODUCT DESIGN……………………………………………………………………………………..39
5.1 INTRODUCTION………………………………………………………………………………………………………………. 39
5.2 ENTITY RELATIONSHIP DIAGRAM (ERD)……………………………………………………………………….39
5.3 USE CASE DIAGRAM……………………………………………………………………………………………………….40
5.3 STAR SCHEMA…………………………………………………………………………………………………………………41
5.4. DATA FLOW DIAGRAM (level 1 diagram)………………………………………………………………………….42
5.4.1. STAFF DATAFLOW DIAGRAM………………………………………………………………………………….42
5.4.2 TRAVELER DATA FLOW DIAGRAM…………………………………………………………………………..43
5.4.3 ADMIN DATAFLOW DIAGRAM………………………………………………………………………………….44
5.5 CONTEXT DIAGRAM………………………………………………………………………………………………………..45
5.6 ACTIVITY DIAGRAM FOR TRAVELER, STAFF AND ADMIN……………………………………………46
5.7 DATA DICTIONARY FOR ENTITY RELATIONSHIP DIAGRAM……………………………………47
5.8 STAR SCHEMA DATA DICTIONARY………………………………………………………………………………..50
CHAPTER SIX: PRODUCT IMPLEMENTATION AND TESTING……………………………………………..52
6.1 INTRODUCTION………………………………………………………………………………………………………………. 52
6.2 THE CONSTRUCTIVE PHASE OF THE PROPOSED SYSTEM……………………………………………..52
6.3 REQUIRED PLAN FOR THE PROPOSED SYSTEM……………………………………………………………..52
6.4 THE SYSTEM DEVELOPMENT ENVIROMENT………………………………………………………………….52
6.4.1 HARDWARE………………………………………………………………………………………………………………. 52
6.4.2 SOFTWARE REQUIRED FOR THE PROPOSED SYSTEM DEVELOPMENT…………………..53
6.5 IMPLEMENTATION OF THE PRODUCT…………………………………………………………………………….54
6.5.1 PROPOSED SYSTEM INTERFACE……………………………………………………………………………….54
6.5.2 The login page………………………………………………………………………………………………………………55
6.5.3 Valid user login page……………………………………………………………………………………………………55
8
6.5.4 Home page……………………………………………………………………………………………………………………56
6.5.5 Graphical analysis on traveler………………………………………………………………………………………….56
6.5.6 Graphical analysis on transportation…………………………………………………………………………………57
6.5.7 Graphical analysis on location…………………………………………………………………………………………57
6.5.8 Graphical analysis on accommodation………………………………………………………………………………58
6.5.9 Historical data (data warehouse)………………………………………………………………………………………58
6.6 Testing of product………………………………………………………………………………………………………………..59
6.7 CONCLUSION…………………………………………………………………………………………………………………..59
CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION……………………………………………….60
7.1 INTRODUCTION………………………………………………………………………………………………………………. 60
7.2 EVALUATION OF PRODUCT…………………………………………………………………………………………….60
CHAPTER EIGHT: SUMMARY………………………………………………………………………………………………..61
8.1 INTRODUCTION………………………………………………………………………………………………………………. 61
8.2 INFORMATION GATHERING……………………………………………………………………………………………61
8.3 RESULTS…………………………………………………………………………………………………………………………..62
8.4 FUTURE ENHANCEMENT…………………………………………………………………………………………………62
REFERENCE…………………………………………………………………………………………………………………………..62
9
CHAPTER ONE
1.1 INTRODUCTION
Tourism is quickly getting to be a standout amongst the most operative and efficient industries
on the globe. It has extraordinary positive effects in countries by making work opportunities, by
creating or developing infrastructure, and an extremely rich wellspring of wage and income
(IPROJECT, 2016).
Tourism enhances a country’s infrastructural advancement. It makes for provision, for example,
great communication and transport system, low-cost and agreeable lodging, and key
infrastructure. Tourism makes an impressive effect on the change of the general components of
the earth, the organization of hotels and associated businesses. It likewise gives advantages that
come as procurement of important framework, procurement of power, the development of
streets, and convenient water supply and sewage transfer framework (IPROJECT, 2016).
Tourism improves the soul of unity among residents of different countries, makes and enhances
noteworthy relationship and joined society. The conservation and improvement of the tradition,
and local handcraft makes unmistakable nearby tourism items and this thusly gives path for
advancement and familiarity with the Nation’s legacy (IPROJECT, 2016).
Nigeria’s emerging tourism industry can be compared to the nation itself, having various and
predominantly unrealized potential, a scene rich in social legacy and history. The 800 km of
sandy shorelines on the coast, to the tropical beach front plain inland, the mangrove bogs of the
Niger delta, toward the south eastern backwoods belt. Savanna meadows cover the focal areas
and further north the geology changes to hot, semi-parched bushland. These shifted areas contain
mind blowing waterfalls, mountain ranges, wetlands, National Parks and World Heritage locales.
Nigeria is home to more than 250 ethnic gatherings, each with its own legacy and traditions. It is
vivid, energetic and accommodating (Nigeriaembassy.jp, 2016).
1.2 AIM
To design and implement tourism database management system by using data warehouse
approach to make decision.
1.3 OBJECTIVES
To identify current challenges faced by tourism management system in Nigeria.
To analyze data warehouse concepts in implementation of tourism database management.
13
To select suitable methodology in implementation of tourism management system.
To design database and dimensional model for tourism management system.
To implement tourism management system using the concept of data warehouse.
To specify a data model for the system using appropriate tools.
Designing a user friendly oracle APEX interface for user interaction, update, delete, and
adding of information for example location, traveler and other relevant information.
Creating an APEX application to store and manage any relevant information for the
project.
Combining the designs in the aforementioned objectives to form a system.
To test the system, to make decision.
1.4 PROBLEM STATEMENT
Tourism as a vital sector of the economy, the government would like to know some statistical
analysis on how vibrant and lucrative the sector is. But arriving at this expectation is quite
difficult to come up with, due to manual documentation of traveler’s information which
consumes the employees working time, making them stay back at workplace late, and not having
a better knowledge of most visited areas, total number of foreign tourists and many other issues.
Therefore, the proposed system will offer tourist and government agency the opportunity to
know number of arrivals by month, year and total number of people in various locations, this will
also help managers having easy and fast access to information to accelerate their daily activities,
and to make appropriate decisions.
1.5 SCOPE
The scope of the project is entirely and specifically restricted to the projects objectives and
reason for undertaking it which is to mitigate the existing complains on internal
administrative challenges of the existing system. The coverage will be as follows:
The admin will be able to edit, delete, view, update, and add traveler, staff,
accommodation, and transportation with location information.
A staff with edit privilege will be able to view and make editing where necessary.
A traveler who has no access to the system can register to view several reports.
A user of the system can only have access to the system when he/she is a valid user.
14
A database and apex application will be created to manage staff details, location, traveler,
accommodation, transport information and more other reports.
Data warehouse report such as: Total number of tourists that visited a particular location,
total revenue derived from transportation, accommodation and travelers for a month,
year, will be ascertain. More so, most visited location will be considered.
This project will not cover traveler updating their information, make booking, and payment.
IF YOU CAN'T FIND YOUR TOPIC, CLICK HERE TO HIRE A WRITER»
