Whenever you're ready, walk me through how you'd approach this.
What are the key considerations when designing a database schema?
Discuss how requirements, data relationships, integrity constraints, normalization, query patterns, indexing, scalability, and future changes influence the design. Explain the trade-offs between a fully normalized schema and selective denormalization.