-
Tourism Database Management System Using Data Warehouse Approach
CHAPTER FOUR -- [Total Page(s) 2]
Page 2 of 2
-
-
-
4.1.1.1 PROPOSED SYSTEM REQUIREMENTS
The following stride in a way
to deal with developing the tourism database management system started
by helping users to put their requirements. An arrangement of dialog
sessions were held to get the requirement from the expected users.
Notwithstanding posting the users' requirement, the developer
categorized them into functional and non-functional requirements to
highlight their execution needs.
4.1.1.1.1 FUNCTIONAL REQUIREMENTS
The
functional requirements characterizes what the tourism database
management system using the data warehouse approach is likely to do,
which entails:
â–ª The system would perform the editing, updating,
adding and deleting location, accommodation, transportation, traveler
and staff information.
â–ª It will give expected reports based on the available entities like total number of arrivals
by year, top visited area and total number of tourists, top used accommodation type by tourist.
▪ You can’t have access to the system except you’re authenticated.
4.1.1.1.2 NON-FUNCTIONAL REQUIREMENT
Characterizes less vital requirement, which include:
â–ª Speed
The proposed system was developed in a way of giving the user a quick response to queries.
â–ª Simplicity
Utilizing and learning of proposed system shouldn’t require any extraordinary skills.
â–ª Reliability
The
proposed system using the data warehouse approach was designed in a way
that could be reliable, able to generate reports required by the user.
â–ª Maintainability and scalability
The
DW is to acknowledge and accept the future changes what's more, the
normal upgrades as indicated by the progressions in the client
requirement.
4.1.2 USER DESIGN PHASE
This is the phase wherein
different design techniques were employed to aid the modeling of the
system, entity relationship diagram, use case and many others were used
by the developer as part of its techniques in planning the structure,
functionality of the proposed system. Some tools were used, tools like
QSEE Superlite in developing the Entity Relationship Diagram (ERD), Use
Case and so on (Blueink.biz, 2016).
4.1.3 CONSTRUCTION PHASE
This
is the system development stage, the system was developed using mainly
sql queries, procedural language, Apex technology and a bit of HTML. The
development of the system involves a cycle of iteration and testing
until the system was fully developed.
4.1.4 IMPLEMENTATION PHASE
The
implementation stage states how the project can be developed, the
processes involved in the development of the project. For example, the
entities of the project must be identified, after the identification
they must be created using sql statement. Additionally, apex user
interface will be created to enable users to interact with the system.
CHAPTER FOUR -- [Total Page(s) 2]
Page 2 of 2
-
-
ABSRACT - [ Total Page(s): 1 ]ABSTRACTTourism 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 ... Continue reading---
CHAPTER SEVEN - [ Total Page(s): 1 ]CHAPTER SEVEN: PRODUCT AND PRODUCT EVALUATION7.1Â Â Â INTRODUCTIONThe expectation of every system developer is to see that the conceptual system is brought to a reality. Therefore, at this phase the system was fully developed. The evaluation of the proposed system was considered in more details in this chapter. This involves the difficulties encountered, the successes in line with the proposed objectives.7.2Â Â Â EVALUATION OF PRODUCTThe evaluation of the product will be based on the objective ... Continue reading---
LIST OF TABLES - [ Total Page(s): 1 ]Lists of TablesTable 5.1Table 5.2Table 5.3Table 5.4Table 5.5Table 5.8.1Table 5.8.2Table 5.8.3Table 5.8.4 ... Continue reading---
LIST OF FIGURES - [ Total Page(s): 1 ]List of figuresFigure 2.1Figure 3.1Figure 3.2Figure 3.3Figure 3.4Figure 3.6Figure 3.7Figure 3.8Â Â Â Figure 3.8Â Â Â Figure 3.9Â Â Â Â Â Â Figure 5.1Â Â Â Â Â Â Â Figure 5.2Â Â Â Â Â Â Â Â Â Figure 5.3Â Â Â Â Â Â Â Â Â Figure 5.4Â Â Â Â Â Â Â Â Â Figure 5.5Â Â Â Â Â Â Â Â Â Figure 5.6Â Â Â Â Â Â Â Â Â Figure 5.7Â Â Â Â Â Â Â Â Â Figure 5.8Â Â Â Â Â Â Â Â Â Figure 6.5.2.1Â Â Â Â Â Â Figure 6.5.2.2Â Â Â Â Â Â Figure 6.5.2.5Â Â Â Figure 6.5.2.6Figure 6.5.2.7Â Â Â ... Continue reading---
TABLE OF CONTENTS - [ Total Page(s): 1 ]Table of contentsCHAPTER 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 ... Continue reading---
LIST OF ABRIVATIONS - [ Total Page(s): 1 ]List of symbols/AbbreviationsS/NÂ Â Â ABBREVIATIONÂ Â Â MEANINGS1Â Â Â OLAPÂ Â Â Online Analytical Processing2Â Â Â ROLAPÂ Â Â Relational online analytical processing3Â Â Â MOLAPÂ Â Â multidimensional online analytical processing4Â Â Â OLTPÂ Â Â online transaction processing5Â Â Â MOTÂ Â Â Ministry of Tourism Malaysia6Â Â Â SQLÂ Â Â Structured Query Language7Â Â Â CSVÂ Â Â comma-separated values8Â Â Â HTMLÂ Â Â Hypertext Markup Language9Â Â Â PDFÂ Â Â Portable document format ... Continue reading---
CHAPTER EIGHT - [ Total Page(s): 1 ]CHAPTER EIGHT: SUMMARY8.1Â Â Â INTRODUCTIONAs usual, developing a system requires information gathering, findings which will eventually stand as the pillars for the proposed system development. Having find the required information, then it involves proper planning, analysis, scope, objective, aim and so on of the proposed system. The information gathering is based on the proposed project titled: Tourism Database Management System which will eventually resolve the challenges faced by the tourism ... Continue reading---
CHAPTER ONE - [ Total Page(s): 1 ]CHAPTER ONE: INTRODUCTION1.1Â Â Â INTRODUCTIONTourism 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 a ... Continue reading---
CHAPTER TWO - [ Total Page(s): 4 ]2.3.1Â Â Â BOTTOM TIERThe bottom level of the architecture is the data warehouse database server. It is the relational database framework. The back end tools and utilities are used to input data into the bottom level. These back-end tools and utilities carry out the Extract, Clean, Load, and refresh functions.2.3.2Â Â Â MIDDLE TIERIn the middle level, we have the OLAP Server that can be actualized in both of theaccompanying ways: ... Continue reading---
CHAPTER THREE - [ Total Page(s): 8 ]The below figure 5 indicates the adding of department name column to the employee report using the graphical interface.Figure 3.6 (Docs.oracle.com, 2016)3.2.3Â Â Â FLASH CHARTSApplications can be worked to utilize Adobe's Flash Player browser plug-in to show charts. There are a few sorts of Flash Charts bolstered including column, bar, pie, doughnut, scatter, line, candle, gauge, Gantt, and Flash Maps. Amid the creation procedure you can review the chose type and set most attribute for the ensu ... Continue reading---
CHAPTER FIVE - [ Total Page(s): 11 ] ... Continue reading---
CHAPTER SIX - [ Total Page(s): 7 ]The above data warehouse was gotten after being through the ETL (Extraction, Transformation, and Loading) process. Four hundred and eighty five values where loaded into the fact table. The report met the proposed aim and objectives.Please refer to appendix G for more interfaces.Please refer to appendix B for more testing6.7Â Â Â CONCLUSIONHaving gone through the testing phase, the basic functionality where met. ... Continue reading---
REFRENCES - [ Total Page(s): 1 ]REFERENCEAhmed, M. (2013). Practical steps for using Amazon EC2 IaaS Technology. An introduction to cloud computing concepts, pp.1-4.Blueink.biz. (2016). blueink.biz - Rapid Application Development - An Application Development Technique Using Prototypes, Iterative Customization, and CASE Tools. [online] Available at: http://www.blueink.biz/RapidApplicationDevelopment.aspx [Accessed 23 Aug. 2016].David, G., Sue, H., Christopher, J., Alex, K., Bryn, L., Kuassi, M., David, P. and Christian, S. (201 ... Continue reading---
