VOOZH about

URL: https://www.geeksforgeeks.org/questions/let-r-a-b-c-d-e-p-g/

⇱ 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
Share your thoughts in the comments
GeeksforGeeks