The conflicts between design efficiency,information requirements,and processing speed are often resolved through ____.
A) conversion from 1NF to 2NF
B) conversion from 2NF to 3NF
C) compromises that include denormalization
D) conversion from 3NF to 4NF

Question

Quizplus · Accepted Answer

Compromises that include denormalization are often used to resolve conflicts between design efficiency, information requirements, and processing speed. Denormalization involves intentionally adding redundant data to a database to improve performance by avoiding joins or reducing the number of tables that need to be accessed. This sacrifices some of the benefits of normalization, but can be a useful tradeoff in certain situations. Conversions between different normal forms (1NF, 2NF, 3NF, 4NF) do not directly address these conflicts.

The Conflicts Between Design Efficiency,information Requirements,and Processing Speed Are Often