Registered: 14 years ago
Hi I need some help with understanding foriegn keys.
The way I understand them is that in the relationship TEACH both LecturerNumber and CourseNumber are foreign keys seeing the lecturer number would be looked up from the Lecturer table and the CourseNumber would be looked up from the COURSES table.
The same can be said of relations TEACHING ASSISTANTS and ENROLLED. In the relationship ENROLLED CourseNumber and StudentNumber are foreign keys.
Tutorial letter 202 listed only DepartmentNumber of LECTURERS and COURSES as foreign keys simply because they double underlined.
I did try my approach in the assignemnt and it was marked wrong I am guessing simply because the foreign key i chose was not double underlined.