You should strive to create databases that use ____ rules for normalization.
A) zero normal form
B) first normal form
C) second normal form
D) third normal form

Question

Quizplus · Accepted Answer

The best choice is third normal form (3NF) because it ensures that data is organized efficiently and avoids duplication. 3NF eliminates all transitive dependencies between non-key attributes, which means that every non-key attribute is functionally dependent on the primary key. This reduces data redundancy and helps maintain consistency and integrity. Zero normal form (0NF) and first normal form (1NF) are not considered adequate for practical database design, while second normal form (2NF) is not as effective as 3NF since it only eliminates partial dependencies.

You Should Strive to Create Databases That Use ____ Rules