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
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy