Multiple choice

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\rightarrow$ G, A $\rightarrow$ BC, B $\rightarrow$ CFH, E $\rightarrow$ A, F $\rightarrow$ 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

  1. in INF, but not in 2NF

  2. in 2NF, but not in 3NF

  3. in 3NF, but not in BCNF

  4. in BCNF
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A $\rightarrow$ BC, B $\rightarrow$ CFH and F $\rightarrow$ EG are partial dependencies. Hence, it is in 1NF but not in 2NF.

Keep practicing — related questions