At the beginning of the video facts, dimensions, and measures.
Add 120 measures are stored in fact tables, and dimensions are stored in to mention tables.
At 2:05 in the snowflake schema the dimension tables are normalized.
video-star-schema-versus-snowflake-design#snowflake-normalized-star-schema-not-normalized1 2At 2:45 snowflake schema can have normalized dimension tables, but star schema has purely denormalized dimension tables. video-star-schema-versus-snowflake-design#snowflake-normalized-star-schema-not-normalized1 2
At 3:30 star schema is harder to maintain because it is the denormalized, but the joins are easier because there are few were tables to join against.