Home » MCQs » DBMS MCQs » DBMS Normalization MCQs

There needs to be which of the following conditions for each nontrivial dependency of function X on function Y for a relation to be in third normal form

19. There needs to be which of the following conditions for each nontrivial dependency of function X on function Y for a relation to be in third normal form.

1. A super key is X.
2. Every element of Y is a part of some candidate key, i.e, Y is a prime attribute.
3. Either A or B
4. None of the above

Answer: C) Either A or B

Explanation:

There needs to be at least one of the following conditions for each nontrivial dependency of function X on function Y for a relation to be in third normal form.

1. A super key is X.
2. Every element of Y is a part of some candidate key, i.e, Y is a prime attribute.