What distinguishes a snowflake schema from a star schema?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What distinguishes a snowflake schema from a star schema?

Key points

Snowflake schema: normalized dimension tables
Star schema: denormalized dimension tables
Snowflake schema: multiple related tables for dimensions
Star schema: single tables for dimensions
Snowflake schema: more complex relationships between tables

Ready to go further?

Start full exam Practice more questions

Related questions