Exam-style question
Try this first
A relation has a composite key made from StudentID and CourseID. Which dependency would be appropriate for an attribute representing a student's grade for that course?.
- A.Grade depends on StudentID only.
- B.Grade depends on CourseID only.
- C.Grade depends on both StudentID and CourseID.
- D.Grade depends on neither StudentID nor CourseID.
Model answer
What a good answer should say
- Grade depends on both StudentID and CourseID.
Explanation
Why this works
A grade is associated with a particular student taking a particular course, so it depends on the whole composite key. Dependence on only part of the key would be a partial dependency.
Common mistake
No common mistake is linked to this question yet.