I'm a beginner and student with regards to database design. The tutor recently discussed “part-keys”. I am struggling to find any information on what a part-key is, and I suspect it probably goes by another name.
The example we were given in class was this:
ACTIVITY(Activity(PK), Fee) STUDENT_ACTIVITY(StudentID(PK), Activity(PK))
Is the table showing part-key dependency?
Yes. Since the second determinant (
Activity) is part of the primary key (
Is anyone able to give me any further information?