GATE | Gate IT 2008 | Question 60

Let R (A, B, C, D, E, P, G) be a relational schema in which the following functional depen­dencies are known to hold: AB → CD, DE → P, C → E, P → C and B → G. The relational schema R is

(A) in BCNF
(B) in 3NF, but not in BCNF
(C) in 2NF, but not in 3NF
(D) not in 2NF


Answer: (D)

Explanation: Candidate key = AB
B->G is partial dependency
So, not in 2NF

Quiz of this Question

My Personal Notes arrow_drop_up

Save