Consider the attributes ABCDEFGH in the relation R. Each attribute of R contains only atomic values. The functional dependencies on those attributes J = {CH → G, A → BC, B → CFH, E → A, F → EG}, such that J+ 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 rating: 100% (QA)

The detailed answer for the above question is provided below The answer is B in 2NF but not in 3NF H... View the full answer