-
The relational schema Student Performance (name, coureNo., rollNo., grade) has the following functional dependencies
name, courseNo. → grade
rollNo., courseNo. → grade
name → rollNo
rollNo. → name
The highest normal form of this relation schema is
-
- 2NF
- 3NF
- BCNF
- 4NF
- 2NF
Correct Option: B
For easy understanding let's say attributes (name, courseNo, rollNo, grade) be (A,B,C,D) Then given FDs are as follows :
AB → D, CB → D, A → C, C → A
Here there are two Candidate keys, AB and CB.
Now AB → D and CB → D satisfy BCNF as LHS is superkey in both.
But, A → C and C → A, doesn't satisfy BCNF. Hence we check for 3NF for these 2 FDs.
As C and A on RHS of both the FDs are prime attributes, they satisfy 3NF.
Hence for the whole relation the highest normal form is 3NF.
