1.

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F={CH→G, A→BC, B→CFH, E→A, F→EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R. The relation R is

A. in 1NF, but not in 2NF.
B. in 2NF, but not in 3NF
C. in 3NF, but not in BCNF
D. in BCNF.
Answer» B. in 2NF, but not in 3NF


Discussion

No Comment Found

Related MCQs