The relation scheme student performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, curseNo --> grade
Rol INo, courseNo —> grade
name —> rollNo
rollNo —> name
The highest normal form ofthis relation scheme is:
A. | 2 NF |
B. | 3 NF |
C. | BCNF |
D. | 4 NF |
Answer : B Explanation : Soniya said: (12:29am on Sunday 18th June 2017)
It's not even in 2NF
|
|
Option: A Explanation : Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. Explanation will come here. |