Difference between ER Modeling and Dimensional ModelingThe entity-relationship model is a method used to represent the logical flow of entities/objects graphically that in turn create a database. It has both logical and physical model. And it is good for reporting and point queries.
Dimensional model is a method in which the data is stored in two types of tables namely facts table and dimension table. It has only physical model. It is good for ad hoc query analysis.
Difference between ER Modeling and Dimensional ModelingDimensional modeling is a form of modeling of data that is more flexible for the perspective of user. The ER modeling is for databases that are OLTP databases which uses normalized data using 1st or 2nd or 3rd normal forms.
Dimensional Modeling is used in data warehouses that uses 3rd normal form. It contains denormalized data.