Complete the step process for designing dimensional models

Assignment Help Data Structure & Algorithms

Reference no: EM13216370

Requirement 1

Complete the 4 step process for designing dimensional models for each process you identify.

1. Business Process

2. Grain

3. Dimensions

4. Facts

Requirement 2

Create a data warehouse bus matrix

Requirement 3

Create a dimensional model (star schema) for each process you identify Align this with Requirement 1.

Additional Requirements/Notes

Identify all attnbutes for fact and dimension tables

To make your dimensional models mom readable/manageable. you can present the dimension tables individually first, and then when providing the star schema, present an abbreviated dimension with key fields only.
Clearly mark surrogate keys ISK), business keys (bKI and degenerate dimensions (DO) , role playing dimensions/dimension attributes (RP), and other important identifier, as discussed in
class

Identify the type of fact tables you are going to employ

Provide any assumptions on business requirements

Hand drawn diagrams are acceptable as long as they're neat and legible. Scan ynur hand drawn diagrams and submit to D2L.

Download:- Algo.zip

Reference no: EM13216370

Questions Cloud

How alcohol may cause damage to cellular enzymes : Utilizing the information in "Cirrhosis: Many Causes " answer the following prompt. Focusing on long-term abuse of alcohol as a cause of cirrhosis, speculate how alcohol may cause damage to cellular enzymes (hint: what can cause destabilization of..

Describe in detail its behavior-ritual-belief and experience : Select a religion and describe in detail its behavior: ritual, belief, and experience; describe why you chose this type of religion and what it means to you on a personal level and its connection to you.

Which population of vesicles has a surface similar cell : Which population of vesicles has a surface similar to that of the cell? Why?

Prevent a lethal epidemic in the united states : Ignoring the constitutionality of such a law, choose one of the following positions and, in writing, present a scientifically persuasive case for why Congress should adopt your position.

Complete the step process for designing dimensional models : Complete the step process for designing dimensional models for each process you identify and create a dimensional model (star schema) for each process you identify Align

Why do my balls ooze green and blue puss : why do my balls ooze green and blue puss when I sit on them and I get a tingly sensation and it tastes of clotted cream?

Explain possible consequences of ineffectiveness : Describe the responsibilities of judges. Identify attributes of both effective and ineffective judges. Provide an example of an effective and an ineffective Supreme Court judge. Explain possible consequences of ineffectiveness.

How many histone molecules must be transported per second : assuming that 32 million histone octamers are required to package the human genome, how many histone molecules must be transported per second per pore complex in cells whose nuclei contain 3000 nuclear pores and are dividing once per day? Explain.

Explicit policy and implicit policy elements : what are the differences between explicit policy, and implicit policy elements

User Account

All Pages