Let R (A, B, C, D, E, P, G) be a relational schema in which the following…
GATE · 2008 · IT
Let R (A, B, C, D, E, P, G) be a relational schema in which the following functional dependencies 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
Attempted by 507 students.
Sign up free to check your answer
Sign up freeLoading lesson…