All of the following are common denormalization opportunities EXCEPT:
A) two entities with a one-to-one relationship.
B) a one-to-many relationship.
C) a many-to-many relationship with nonkey attributes.
D) reference data.

Question

Quizplus · Accepted Answer

A one-to-many relationship is typically not a denormalization opportunity because it is a standard relational database structure that maintains normalization. Denormalization usually involves combining tables or reducing the number of joins needed, which is not typically necessary for one-to-many relationships.

All of the Following Are Common Denormalization Opportunities EXCEPT