-
Tourism Database Management System Using Data Warehouse Approach
-
-
-
3.2.1 ORACLE APPLICATION EXPRESS
In the past, Oracle Application Express was referred to as HTML DB, is a quick Web application improvement device for the Oracle Database. Utilizing just a Web browser and narrow programming knowledge, you can create and convey proficient applications that are both quick and secure. No customer programming is required to create, convey or run Oracle Application Express applications. Oracle Application Express is (Oracle Apex) made for the Web and joins the characteristics of a workgroup database (i.e., profitability, usability and adaptability) with the characteristics of a workgroup database (i.e., security, honesty, versatility and accessibility). Oracle Application Express is a perfect instrument for rapidly constructing resourceful and departmental applications and is a "no cost" choice of the Oracle Database (David et al., 2010).
The following tools are found in Oracle Application Express:
â–ª Application Builder: It is used to make dynamic database-driven Web applications.
â–ª SQL Workshop: To skim database objects, run specially appointed SQL queries, and additionally a graphical query builder. Utilities are given to load and empty data, set UI defaults, create DDL scripts, and review different parts of the database.
â–ª Team Development: It was developed to manage software development projects utilizing integrated components, to-dos, milestones and feedback
â–ª Administration: This is also developed to manage the Application Express Workspace including dealing with the service, looking after clients, and monitoring various activities (David et al., 2010).
With Oracle Application Express you can without much of a stretch form applications that report on database information. Reports can be hypertext connected with different reports permitting clients to explore through database information similarly they explore Web locales. Segments in reports can be effectively connected to different reports, charts, and information entry form. A broad diagramming engine permits SQL queries to be portrayed graphically. Oracle Application Express is likewise extremely proficient at altering database information and backings countless structure controls including radio gatherings, checkboxes, select records, shuttles, word processors and date pickers (David et al., 2010).
-
-
-
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 FOUR - [ Total Page(s): 2 ]CHAPTER FOUR: PROPOSED METHODOLOGY4.1Â Â Â SYSTEM METHODOLOGYFor any system to be developed it must undergo some processes or stages to become a complete system. So system methodology is a scheme that is employed to structure, plan and control the way toward building up a functional system (Itinfo.am, 2016).There are numerous methodology used in the development of project, amongst others RAD and Agile methodology will be given more consideration in order for the developer to choose and justify ... 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---
-
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---