+234 813 0686 500
+234 809 3423 853
info@grossarchive.com

Tourism Database Management System Using Data Warehouse Approach

  • Type:Project
  • Pages:65
  • Format:Microsoft Word
(Computer Science Project Topics & Materials)



  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

PDF

Portable document format


10

RTF

Rich Text Format















Tourism Database Management System Using Data Warehouse Approach

Share This

Details

Type Project
Department Computer Science
Project ID CPU1572
Price ₦3,000 ($9)
No of Pages 65 Pages
Format Microsoft Word

500
Leave a comment...

    Details

    Type Project
    Department Computer Science
    Project ID CPU1572
    Price ₦3,000 ($9)
    No of Pages 65 Pages
    Format Microsoft Word

    Related Works

    ABSTRACT This project work intends to provide architecture for the technology in building of a standard, sophisticated and user-friendly data warehouse system which is platform independent and secured. The proposed work surely addressed the limitations identified within the scope of this project... Continue Reading
    ABSTRACT The project is the design and implementation of database federation of public database of Nigerians using database links and web services. It involves the design of a representative of the primary database that houses comprehensive information about Nigeria residences; other smaller databases representing some of the government agencies... Continue Reading
    INTRODUCTION The dictionary defines accident as “an unexpected and undesirable event, a mishap, unforeseen and without apparent cause. The mounting toll of Road Traffic Accident (RTA) deaths in Nigeria has public health problem, which requires urgent attention since these deaths are preventable. The pattern of scold sustained in these fatalities... Continue Reading
    CHAPTER ONE INTRODUCTION: This chapter gives an overview about the aim, objectives, background and operation environment of the system. 1.1 BACKGROUND OF THE STUDY Library ManagementSystem is an application which refers to library systems which are generally small or medium in... Continue Reading
    ABSTRACT In the early years, the use of humans and paper work in tracking distribution of goods was a norm but there was a gap in the chain process. The manual method or intervention is labour intensive, costly, and error prone and cannot ensure the inventory remains up-to-date due to oversight and internal shrinkage. Hence the need to replace... Continue Reading
    ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities involve the acquisition of data and processing. As exploration activities increases in the modern world, the computer manufacturers are also working hard to produce... Continue Reading
    DESIGN AND IMPLEMENTATION OF COMPUTERIZED INFORMATION MANAGEMENT SYSTEM IN SEISMIC DATA PROCESSING (A CASE STUDY OF INTEGRATED DATA SERVICES LIMITED, IDSL BENIN-CITY) ABSTRACT Oil industry is a prominent aspect of modern economy and as it were exploration activities are very important for continuity of oil production. The exploration activities... Continue Reading
    ABSTRACT This project work is designed to ease the task involved in maintaining adequate information in tourism board Enugu. This work researched into the area of data entry processing and report generation. The problems associated with them were detected and possible solutions were carefully implemented in the new design. The computer... Continue Reading
    ABSTRACT The study was carried out to verify all the manual processes involved in patient management system and to seek for a way of automating the system for effective operations. Since, there is continuous moves towards technological advances that enhanced productivity of... Continue Reading
    TABLE OF CONTENT Approval/Certification                                                                                    ii... Continue Reading