Database Analyst Interview Question:

Tell us when might someone denormalize their data?

Submitted by: Muhammad

Typically done for performance reasons, to reduce the number of table joins. This is not a good idea in a transactional environment as there are inherent data integrity risks or performance risks due to excessive locking to maintain data integrity.

Questions related to the Unified Modeling Language (UML) or Entity-Relationship Diagrams (ERDs) may also be asked here.
Submitted by: Muhammad