Create the dimensional model for your problem

A$.$ You will do this on your DW environment $($ SQL$,$ Oracle..$)$

B$.$ Submit ER Diagrams from your dimensional model with details

$2.$ Include in your design FACT and DIMENSIONAL tables

$3.$ Show, Primary and Foreign Keys, relationships through ER diagram

$4.$ Show attributes of each of the DIMENSIONAL table

$5.$ Align and Ensure Measures in the FACT table$($s$)$

$6.$ Identify $$AGGREGATE$$ tables $($ also a FACT table$)$

$7.$ Identify any Snowflakes $($show how you addressed them$)$

A$.$ If you don$$t have Snowflake, Discuss how you plan to address if you have one

B$.$ If you have one, demonstrate how you are eliminating per Kimball's

methodology

Table Requirements

$2-4$ FACT tables

$2-3$ corresponding DIMENSIONAL tables aligned to each FACT table

$$ Populate FACT tables $($measures$)$

Assignment $3$ Two Parts $($ A& B $)$