UGC-NET | UGC NET CS 2014 Dec – II | Question 19

The best normal form of relation scheme R(A, B, C, D) along with the set of functional dependencies F = {AB → C, AB → D, C → A, D → B} is
(A) Boyce-Codd Normal form
(B) Third Normal form
(C) Second Normal form
(D) First Normal form

Answer: (B)
Explanation: Here C-> A (prime attribute -> prime attribute) and D->A (prime attribute -> prime attribute) is partially dependents FDs . This type of FD must not be in BCNF and there is no problem with this type of FDs in 3NF.

Option (B) is correct.
Quiz of this Question