*IMPORTANT PLEASE READ

picture 1: (directions/assignment/task at hand)

picture 2: entity relationship model

picture 3: contents of data table

Assignment \#2: Dimensional Modeling Instruction: - Convert the following ER model to a dimensional model to evaluate the sales performance measure by sales dollars and units sold. - Use MS PowerPoint (recommended but not limited) to draw the dimensional model and paste it on the Word file. - Steps: o Determine the measure type attributes that will be in the fact table o Designate the fact table o De-normalize all remaining tables into flat tables o Create the dimension tables Entity-relationship model: Contents of the data Tables: Assignment \#2: Dimensional Modeling Instruction: - Convert the following ER model to a dimensional model to evaluate the sales performance measure by sales dollars and units sold. - Use MS PowerPoint (recommended but not limited) to draw the dimensional model and paste it on the Word file. - Steps: o Determine the measure type attributes that will be in the fact table o Designate the fact table o De-normalize all remaining tables into flat tables o Create the dimension tables Entity-relationship model: Contents of the data Tables