Differentiate between E-R modeling and Dimensional modeling.

1.3kviews

written 23 months ago by

modified 23 months ago by

ADD COMMENT EDIT

1 Answer

164views

written 23 months ago by

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

ADD COMMENT EDIT

Please log in to add an answer.