Home » MCQs » DBMS MCQs » DBMS Normalization MCQs

What is TRUE about the Third Normal Form (3NF)?

17. What is TRUE about the Third Normal Form (3NF)?

1. When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
2. Data duplication is reduced by using 3NF.
3. It helps maintain the integrity of the data.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Third Normal Form (3NF) -

1. When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
2. Data duplication is reduced by using 3NF.
3. It helps maintain the integrity of the data.