Explain the difference between a star schema and a snowflake schema, and when you would choose one over the other for financial reporting.
