Whenever you're ready, walk me through how you'd approach this.
Explain the difference between star and snowflake schemas, and explain which is more suitable for a high-write financial reporting database.
Compare their dimensional structure, normalization, join behavior, storage characteristics, and impact on inserts and updates. State any assumptions about whether the database is an operational reporting store or an analytical warehouse.