Multiple choice

The relation scheme student Performance (name, courselNo, rollNo, grade) has the following functional dependencies: name, courseNo $\rightarrow$grade RollNo, courseNo$\rightarrow$grade name $\rightarrow$rollNo rollNo $\rightarrow$name The highest normal form of this relation scheme is

  1. 2 NF

  2. 3NF

  3. BCNF

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

Name, course no. $\rightarrow$ grade Roll no. course no. $\rightarrow$ grade Name, Roll no are candidate keys grade depend upon both super keys. So it is 2NF , non key attribute grade depend upon super keys fully. But not in 3NF , since grade is not fully dependent upon all candidate keys.

Keep practicing — related questions