Welcome! Log In Create A New Profile


Assignment 1 Question 2

Posted by tjvanaarde@web.de 
Announcements Last Post
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
Assignment 1 Question 2
September 18, 2006 06:08PM
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.

Sorry, only registered users may post in this forum.

Click here to login