Question

A relation \(R(A,B,C,D)\) with functional dependencies A→B, B→C is in _______ .
 

• A. 1NF but not 2NF
• B. 2NF but not 3NF
• C. 3NF but not BCNF
• D. BCNF

Hint:

To bring a relation into 3NF, remove transitive dependencies and ensure that every non-prime attribute is non-transitively dependent on every key.

Answer 1

The Correct Option is B

In this case, the functional dependency A→B and B→C violates 3NF because B is a non-prime attribute determining another non-prime attribute (C). The relation satisfies 2NF but not 3NF.