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
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
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
Lists of Tables
Table 5.1
Table 5.2
Table 5.3
Table 5.4
Table 5.5
Table 5.8.1
Table 5.8.2
Table 5.8.3
Table 5.8.4
List of figures
Figure 2.1----------------------------------------------------------------------------------18
Figure 3.1----------------------------------------------------------------------------------26
Figure 3.2----------------------------------------------------------------------------------27
Figure 3.3----------------------------------------------------------------------------------29
Figure 3.4----------------------------------------------------------------------------------30
Figure 3.6----------------------------------------------------------------------------------30
Figure 3.7-------------------------------------------------------------------------------------------31
Figure 3.8-------------------------------------------------------------------------------------------31
Figure 3.8-------------------------------------------------------------------------------------------32
Figure 3.9 ----------------------------------------------------------------------------------33
Figure 5.1-----------------------------------------------------------------------------------39
Figure 5.2-----------------------------------------------------------------------------------40
Figure 5.3-----------------------------------------------------------------------------------41
Figure 5.4-----------------------------------------------------------------------------------42
Figure 5.5-----------------------------------------------------------------------------------43
Figure 5.6-----------------------------------------------------------------------------------44
Figure 5.7-----------------------------------------------------------------------------------45
Figure 5.8-----------------------------------------------------------------------------------46
Figure 6.5.2.1------------------------------------------------------------------------------55
Figure 6.5.2.2------------------------------------------------------------------------------56
Figure 6.5.2.5------------------------------------------------------------------------------57
Figure 6.5.2.6-----------------------------------------------------------------------------58
Figure 6.5.2.7-----------------------------------------------------------------------------58
List of symbols/Abbreviations
S/N
ABBREVIATIONS
MEANING
1
OLAP
Online Analytical Processing
2
ROLAP
Relational online analytical processing
3
MOLAP
multidimensional online analytical processing
4
OLTP
online transaction processing
5
MOT
Ministry of Tourism Malaysia
6
SQL
Structured Query Language
7
CSV
comma-separated values
8
HTML
Hypertext Markup Language
9
Portable document format
10
RTF
Rich Text Format