Skip to main content

Relationships

Looking at each table in turn we can find many other relationships. The following shows the columns used to link the tables together.

Table Related table Linking column
Student Department Dept_number
Student Course Course_number
Course Department Dept_number
Unit Course Course_number
Result Student Student_number
Result Unit Unit_number
Attendance Student Student_number
Attendance Unit Unit_number


The student, result and attendance tables each link to two other tables. The student tables link to the department and course tables. The result and attendance tables link to the unit and student tables.

Next: Data Model