ER Modeling is nothing but entity relationship modeling. in this model always call table as entities and it may be second normal form (or) 3rd normal form (or) in between 2nd and 3rd normal form
In this model tables called as dimensions (or) fact tables. It can be subdivided into three schemas.
- Star Schema
- Snow Flake Schema
- Multi Star Schema (or) Hybrid (or) Galaxy