Describe your approach to designing a star schema versus a snowflake schema for a retail sales data warehouse.
