Objective(s):Using an existing, normalized, transaction database, design a data warehouse. The data warehouse should be designed using a star-schema, de-normalized structure. The data warehouse design should also adhere to the best practices.
Methodology:You will be given a small (5 tables), normalized transaction database. Using the guidelines in videos and power point for designing data warehouses, you will create a de-normalized schema for all fields. You must decide what tables should exist in the resulting data warehouse, how those tables will be related, and what fields will be contained in each table. Your design should also take into consideration the reporting and analysis that would ultimately be performed against the data warehouse. (Hint: You may want to begin with possible reporting requirements).
Deliverable(s): You will submit a final design for your data warehouse in an electronic document. The data warehouse design can be created using MS-Word, MS-PowerPoint, or MS-Visio. You are ONLY responsible for the DESIGN LAYOUT of the data warehouse: You are NOT required to build a functioning data warehouse in a DBMS (e.g., MS-Access, Oracle, etc.).
Here is some helpful videos.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post data-warehousing-assignment-1 appeared first on Essay Fount.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
