The relation scheme Student Performance (name, courseNo, rollNo, grade) has…

GATE · 2004 · CS

The relation scheme Student Performance (name, courseNo, rollNo, grade) has the following functional dependencies:

name, courseNo → grade
rollNo, courseNo → grade
name → rollNo
rollNo → name

The highest normal form of this relation scheme is

  1. A.

    2NF

  2. B.

    3NF

  3. C.

    BCNF

  4. D.

    4NF

Attempted by 225 students.

Show answer

Correct answer: B

The worked solution is available to enrolled students.

Video solution available to enrolled students.

Explore the full course: Iocl Engineers Officers Grade A Paper 2

Loading lesson…