The relation scheme Student Performance (name, courseNo, rollNo, grade) has…
2004
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
- A.
2NF
- B.
3NF
- C.
BCNF
- D.
4NF
Attempted by 33 students.
Show answer & explanation
Correct answer: B
First, identify candidate keys. Since name determines rollNo and vice versa, both (name, courseNo) and (rollNo, courseNo) are candidate keys.
Next, check BCNF. FDs name → rollNo and rollNo → name violate BCNF because determinants are not superkeys. However, since right-hand sides are prime attributes, the relation is in 3NF.
A video solution is available for this question — log in and enroll to watch it.