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. | |