Multiple choice

Consider a relation: R(A, B, C, D) with FD A$\rightarrow$BCD BC$\rightarrow$AD D$\rightarrow$B The highest normal form achieved by R is

  1. 1 NF

  2. 2 NF

  3. 3 NF

  4. BCNF

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A, BC and CD are keys. So, FD D$\rightarrow$B violates BCNF definition. Hence, highest normal form is 3 NF.