How do you design a database schema that supports both product features and performance?

Start from the domain model and access patterns. **Steps:** - Identify entities, relationships, and constraints - Normalize first for correctness - Add indexes for hot queries - Denormalize only when measured - Plan migrations and avoid breaking changes **Full stack angle:** align UI needs (filters, sorts) with backend query patterns to avoid expensive scans and N+1 issues.