Understanding the Difference between ER and Dimensional Modeling Please read the PPT slides, the book and these from the web:

1. http://www.dkms.com/papers/dmerdw.pdf ; 2. http://www.information-management.com/issues/20000501/2184-1.html 3. http://intelligent- enterprise.informationweek.com/channels/information_management/showArticle.jhtml;jsessionid =DPHDNU4MGRCEHQE1GHPSKHWATMY32JVN?articleID=217700810 4. https://www.kimballgroup.com/2014/05/design-tip-166-potential-bridge-table-detours/ 5. https://www.kimballgroup.com/ 6. http://www.kimballgroup.com/wp-content/uploads/2013/08/2013.09-Kimball-Dimensional- Modeling-Techniques11.pdf 7. https://vertabelo.com/blog/five-common-dimensional-modeling-mistakes-and-how-to-solve-them/ 8. You can pick up other web documents for this homework if you want.

Then answer the following questions (in this order) 1. Compare and contrast ER modeling with Dimensional modeling. Answer this question by developing a table with three columns like this. Provide 5 attributes in the above table that can show the similarities and 5 attributes that show differences between these two data models.

Attributes to compare ER data model DM data model

................................ ..................... ......................

................................ ...................... .....................

................................ ...................... ......................

................................ ...................... ........................

................................ ....................... ........................

2. List out the Kimball rules for a good dimensional modeling. Why are these rules important to model Dominick data?