Skip to content
Related Articles
Open in App
Not now

Related Articles

GATE | Gate IT 2008 | Question 60

Improve Article
Save Article
  • Last Updated : 28 Jun, 2021
Improve Article
Save Article

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
Related Articles

Start Your Coding Journey Now!