Open In App

GATE | Gate IT 2008 | Question 60

Like Article
Like
Save
Share
Report

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


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads