The relation 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:A
The relation schema R is
A. in BCNF B. in 3NF, but not in BCNF C. in 2NF, but not in 3NF D. not in 2NF
Explanation:From the closure set of attributes we can see that the key for the relation is AB. The FD B->G is a partial dependency, hence it is not in 2NF. Sanfoundry Global Education & Learning Series – Database Management System.