The components of the dimensional model are derived from the information packages in the requirements definition.
The entity-relationship modeling technique is not suitable for data warehouses; the dimensional modeling technique is appropriate.
The STAR schema used for data design is a relational model consisting of fact and dimension tables.
The fact table contains the business metrics or measurements; the dimensional tables contain the business dimensions. Hierarchies within each dimension table are used for drilling down to lower levels of data.
STAR schema advantages are: easy for users to understand, optimizes navigation, most suitable for query processing, and enables specific performance schemes.