Question: what is the difference between e-r model vs. dimensional model?
Answer: ER model contains normalized data where as Dimensional model contains denormalized data. ER modeling that models an ER diagram represents the entire businesses or applications processes. ... This is to say, an ER model will have both logical and physical model. The Dimensional model will only have physical model.