SQL Practice Logo

SQLPractice Online

Level 6 - ExpertDescriptive Questionsm1 data modeling

OLTP Normalization vs Read Model Denormalization

Design interview question: For an order-management platform, when would you keep 3NF in OLTP tables and when would you introduce denormalized read models?