www . foxtutor . com / product / cis-499-week-5-project-deliverable-3- database-and-data-warehousing-design
Project Deliverable 3 : Database and Data Warehousing Design Due Week 5 and worth 110 points
This assignment consists of two ( 2 ) sections : a design document and a revised project plan . You must submit both sections as separate files for the completion of this assignment . Label each file name according to the section of the assignment it is written for . Additionally , you may create and / or assume all necessary assumptions needed for the completion of this assignment .
The use of specific software has been suggested however equivalents including but not limited to OpenOffice , Dia , and Open Project are also permitted . If equivalent tools are used , files must be saved and submitted for grading using extensions that are readable by their equivalent Microsoft Windows edition . Assignment submissions that fail to follow this request may result in a reduced grade .
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage . This feat hinges upon a company ’ s ability to transform data into quality information . The use of relational databases is a necessity for contemporary organizations ; however , data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes . Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems , you must design a solution overview that incorporates data warehousing . The executive team needs to be clear about what data warehousing can provide the company .
Section 1 : Design Document Write a four to six ( 4-6 ) page design document in which you :
Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to .
Create a schema that supports the company ’ s business and processes . Explain and support the database schema with relevant arguments that support the rationale for the structure . Note :