Differentiate between E-R modeling and Dimensional modeling.
|E-R Modeling||Dimensional Modeling|
|Suitable for Online Line Transaction Processing (OLTP) Application||Suggested for Data Warehousing Applications|
|Consists of Entities and Relationships .||Consists of Facts and Dimensions|
|High Create/Read/Update/ Delete (CRUD) activity||High Select Activity|
|Data Redundancy is not desired||Data Redundancy is desired|
|Normalization is suggested||De-Normalization is suggested|