-
Tourism Database Management System Using Data Warehouse Approach
-
-
-
Numerous establishments have encountered the multiplication of workgroup databases. These databases are made principally on the grounds that clients need prompt answers that they can control. Divisions ceaselessly make decentralized databases to comprehend strategic issues. Expenses are driven up as many wasteful, impromptu databases are sent. These databases regularly contain business basic information. They have a tendency to have issues with security, sharing, information precision, and high accessibility. Lamentably, clients of these databases more often than not wind up conflicting with their IT association (David et al., 2010).
The Oracle Application Express solidified model gives decentralized development with brought together administration. Clients can solidify workgroup information and the application development services into Oracle Database 11g with Oracle Application Express. Developers keep up full control over application development while their IT establishment gives proficient data administration. End users encounter significantly enhanced information access by means of present day Web-based applications. Oracle Database 11g guarantees that Oracle Application Express applications are secure, dependable and versatile. The program based outline time interface, decisive programming system and basic wizards make Oracle Application Express a characteristic trade for multi-client workgroup database applications, for example, Microsoft Access (David et al., 2010).
3.2.2 INTERACTIVE REPORT
The region that allows for Interactive Report grant the end users modify reports. The end users can modify the design of report information by picking the sections they are occupied with, applying filters, highlighting, and sorting. Not just that alone, the end users can also describe breaks, accumulations, diverse charts, group bys, and their own calculations. Making varieties of report and saving them as named reports and download to different record designs including comma-delimited record (CSV) position, HTML group, Microsoft Excel (XLS) group, Adobe Portable Document Format (PDF), and Microsoft Word Rich Text Format (RTF). All these can be carried out by the end users (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---