Your question is SQL and Database Design Trade-offs. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Discuss your experience with SQL databases and the trade-offs in database design.
Cover relational modeling, normalization versus denormalization, indexing, transaction behavior, and how you choose between consistency, query performance, storage cost, and maintainability. Use a concrete example from your experience, but focus on the technical reasoning rather than a particular product or company.
Scope: SQL databases and production-oriented relational database design.