Whenever you're ready, walk me through how you'd approach this.
What are the key considerations when designing a data model for a new application?
Discuss how you would identify entities and relationships, select normalization or denormalization strategies, define keys and constraints, plan indexing and partitioning, and support future schema evolution. Also explain how the model should integrate with ETL or ELT pipelines while preserving data quality, lineage, and reliable downstream consumption.