For a database relation R(A, B, C, D) where the domains of A, B and D include only atomic values, only the following functional dependencies and those that…
For a database relation R(A, B, C, D) where the domains of A, B and D include only atomic values, only the following functional dependencies and those that can be inferred from them are :
A → C
B → D
The relation R is in ______
Show answerHide answer
Correct answer: (A) First normal form but not in second normal form
Explanation
No single attribute determines all others. The closure {AB}⁺ = {A, B, C, D}, so AB is the only candidate key. 2NF requires non-prime attributes to be fully dependent on the key, but C depends on A alone and D on B alone (partial dependencies). So R is in 1NF but not in 2NF.