Schema design prompts for chat, e-commerce, and multi-tenant systems. Tables, indexes, and sharding decisions you have to defend.
Each prompt gives you the product requirements and asks for the schema: entities, relationships, the indexes that make the hot queries fast, and the partition key you'd regret picking wrong. The canonical answer covers the tradeoffs, not just the tables.