Tourism Database Management System Using Data Warehouse Approach

Table of contents
CHAPTER ONE: INTRODUCTION   
1.1 INTRODUCTION   
1.2 AIM.   
1.3    OBJECTIVES  
1.4    PROBLEM STATEMENT   
1.5    SCOPE   
CHAPTER TWO: LITERATURE REVIEW   
2.1    INTRODUCTION   
2.2    BACKGROUND STUDY OF TOURISM DEVELOPMENT IN NIGERIA   
2.3    THREE TIER DATA WAREHOUSE   
2.3.1    BOTTOM TIER   
2.3.2    MIDDLE TIER   
2.3.3    TOP TIER.   
2.4    THE NEEDS OF DATA WAREHOUSE CONCEPT IN TOURISM   
2.4.1    CHARACTERISTICS OF DATA WAREHOUSE   
2.4.1.1    SUBJECT ORIENTED WITH   
2.4.1.2    UNIFIED   
2.4.1.3    TIME VARIATION   
2.4.1.4    NONVOLATILE   
2.5    CLOUD COMPUTING   
2.6    BIG DATA COMPUTING   
2.7    DATA WAREHOUSE IN EGYPTIAN TOURISM   
2.7.1    ANALYSIS OF DATA SOURCES.   
2.8    DATA WAREHOUSE IN CHINA TOURISM   
2.9    DATA WAREHOUSE IN ROMANIAN TOURISM   
CHAPTER THREE: REVIEW OF TECHNOLOGIES   
3.1    INTRODUCTION   
3.2    Oracle Database 11g   
3.2.1    ORACLE APPLICATION EXPRESS   
3.2.2    INTERACTIVE REPORT   
3.2.3    FLASH CHARTS.   
3.2.4    DYNAMIC ACTION   
3.2.5    TRIGGER.   
3.3    ETL (EXTRACTION, TRANSFORMATION AND LOADING)   
3.4    CONCLUSION   
CHAPTER FOUR: PROPOSED METHODOLOGY   
4.1    SYSTEM METHODOLOGY   
4.1.1    REQUIREMENTS PLANNING PHASE   
4.1.1.1    PROPOSED SYSTEM REQUIREMENTS   
4.1.2    USER DESIGN PHASE   
4.1.3    CONSTRUCTION PHASE   
4.1.4    IMPLEMENTATION PHASE   
CHAPTER FIVE: PRODUCT DESIGN   
5.1    INTRODUCTION   
5.2    ENTITY RELATIONSHIP DIAGRAM (ERD)   
5.3    USE CASE DIAGRAM   
5.3 STAR SCHEMA   
5.4.    DATA FLOW DIAGRAM (level 1 diagram)   
5.4.1.    STAFF DATAFLOW DIAGRAM   
5.4.2    TRAVELER DATA FLOW DIAGRAM   
5.4.3    ADMIN DATAFLOW DIAGRAM   
5.5    CONTEXT DIAGRAM   
5.6    ACTIVITY DIAGRAM FOR TRAVELER, STAFF AND ADMIN   
5.7    DATA DICTIONARY FOR ENTITY RELATIONSHIP DIAGRAM   
5.8    STAR SCHEMA DATA DICTIONARY   
CHAPTER SIX:  PRODUCT IMPLEMENTATION AND TESTING   
6.1    INTRODUCTION   
6.2    THE CONSTRUCTIVE PHASE OF THE PROPOSED SYSTEM   
6.3    REQUIRED PLAN FOR THE PROPOSED SYSTEM   
6.4    THE SYSTEM DEVELOPMENT ENVIROMENT   
6.4.1    HARDWARE   
6.4.2    SOFTWARE REQUIRED FOR THE PROPOSED SYSTEM DEVELOPMENT   
6.5    IMPLEMENTATION OF THE PRODUCT   
6.5.1    PROPOSED SYSTEM INTERFACE   
6.5.2    The login page.   
6.5.3    Valid user login page   
6.5.4    Home page.   
6.5.5    Graphical analysis on traveler   
6.5.6    Graphical analysis on transportation   
6.5.7    Graphical analysis on location   
6.5.8    Graphical analysis on accommodation   
6.5.9    Historical data (data warehouse)   
6.6    Testing of product   
6.7    CONCLUSION   
CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION   
7.1    INTRODUCTION   
7.2    EVALUATION OF PRODUCT   
CHAPTER EIGHT: SUMMARY   
8.1    INTRODUCTION   
8.2    INFORMATION GATHERING   
8.3    RESULTS.   
8.4    FUTURE ENHANCEMENT   
REFERENCE