Concept: Star Schema vs Snowflake Schema

Star Schemas keep dimension tables denormalized for simplicity and high performance, whereas Snowflake schemas normalize dimensions into sub-tables.