Multiple choice

Consider the following relation R (A, B, C, D, E, F) with FD set A$\rightarrow$BCDEF BC$\rightarrow$ADEF B$\rightarrow$F D$\rightarrow$E The highest normal form achieved by R is

  1. 1 NF

  2. 2 NF

  3. 3NF

  4. BNCF

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

A, BC are keys B$\rightarrow$F violates the 2NF definition.