GATE | IT | 2008 | DBMS | Functional dependency |Question 60

Last Updated :
Discuss
Comments

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

in BCNF

in 3NF, but not in BCNF

in 2NF, but not in 3NF

not in 2NF

This question is part of this quiz :

Database Design(Normal Forms),Gate IT 2008
Tags:
DBMS Quiz
GATE
Share your thoughts in the comments