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)?
- When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
- Data duplication is reduced by using 3NF.
- It helps maintain the integrity of the data.
- All of the above
Answer: D) All of the above
Explanation:
In case of Third Normal Form (3NF) -
- When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
- Data duplication is reduced by using 3NF.
- It helps maintain the integrity of the data.