What is a star schema?

What is a star schema?

Approach: Describe the relationship between fact and dimension tables.

A data modeling technique where a central fact table is connected to multiple denormalized dimension tables. It simplifies queries and improves performance for aggregation.

Follow-up: How does it differ from a snowflake schema?

Key concepts: fact table, dimension table, normalization.