What are the primary differences between star schema and snowflake schema design, and when would you use each?
