Question - What is the difference between E-R modelling and Dimensional modelling?
Answer -
The basic difference is that E-R modeling has a logical and physical model while Dimensional modeling has only a physical model. E-R modeling is required for normalizing the OLTP database design, whereas dimensional modeling is required for de-normalizing the ROLAP/MOLAP design.