Explain the difference between a star schema and a snowflake schema, and describe a scenario where you would choose one over the other.
