

MCQOPTIONS
Saved Bookmarks
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 | |