Home » MCQs » DBMS MCQs » DBMS Normalization MCQs

What is TRUE about 5NF?

23. What is TRUE about 5NF?

1. A relation is in 5NF if it is in 4NF, does not contain any join dependencies, and has lossless joining.
2. In order to avoid redundancy, 5NF ensures that the tables are broken up in as many ways as possible.
3. Project-join normal form (5NF) is sometimes referred to as Project-join NF.
4. All of the above

Answer: D) All of the above

Explanation:

In case of 5NF -

1. A relation is in 5NF if it is in 4NF, does not contain any join dependencies, and has lossless joining.
2. In order to avoid redundancy, 5NF ensures that the tables are broken up in as many ways as possible.
3. Project-join normal form (5NF) is sometimes referred to as Project-join NF.