Question - Below is an instance of the relation schema Student(Student_ID, Course-ID, Student_Name, Grade). Do the following functional dependencies hold on the relation schema Student? Justify your answer for each functional dependency.
(i) Student_ID → Student_Name
(ii) Student _ID → Grade
(iii) Student_ID → Course_ID
(iv) Student_ID + Course_ID → Student_Name
|
Student_ID
|
Course_ID
|
Student_Name
|
Grade
|
|
1000
|
SWEN304
|
Joe M.
|
A+
|
|
1000
|
SWEN222
|
Joe M.
|
A-
|