The conflicts between design efficiency,information requirements,and performance are often resolved through_____.
A)compromises that include normalization
B)conversion from 2NF to 3NF
C)compromises that include denormalization
D)conversion from 3NF to 4NF

Question

Quizplus · Accepted Answer

The conflicts between design efficiency, information requirements, and performance are often resolved through compromises that include denormalization. Denormalization involves intentionally adding redundancy to one or more tables in order to improve query performance at the expense of some write performance. This compromise can help to balance the design efficiency, information requirements, and performance needs of a database system. The other choices (A, B, and D) are not directly related to conflict resolution between design efficiency, information requirements, and performance.

The Conflicts Between Design Efficiency,information Requirements,and Performance Are Often Resolved