Snowflake schema

Multilevel dimensions (normalized into more fine-grained dimensions).

• Uses less space to store dimensions data.
• Easier to maintain.
• Requires more computational resources because of the need to join more tables for the query.