Question: What is the difference between a star schema and a snowflake schema in data modeling?

Answer: A star schema has a central fact table connected to dimension tables, while a snowflake schema extends the star schema by normalizing dimension tables.

Example:

In a star schema, a sales fact table is linked to dimension tables like 'time' and 'product.' In a snowflake schema, the 'time' dimension may be further normalized into 'year,' 'quarter,' and 'month' tables.

Is it helpful? Yes No

Most helpful rated by users:

What is a schema in the context of databases?
Explain the concept of ETL in the context of data engineering.