Which of the following option is false regarding normal forms?
(A) A relation is in normal forms if it fulfills 1NF and in addition, every non – prime attribute should be a fully functional dependency of every candidate key.
(B) A relation is said to be in 3NF if it fulfills 1NF and 2NF and in addition, the no-prime attribute should determine any other non-prime attribute.
(C) A relation is said to be in BCNF if it fulfills 1NF and atleast one determinant should be a candidate key.
(D) None of these.


Answer: (C)

Explanation: Only option (C) is false, because a relation is said to be in BCNF if it fulfills 1NF and every determinant should be a candidate key.

Quiz of this Question