Welcome! Log In Create A New Profile

Assignment 1 Question 2

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

tjvanaarde@web.de

Assignment 1 Question 2
September 18, 2006 06:08PM

IP/Host: ---.tbnb.isadsl.co.za
Registered: 18 years ago
Posts: 62
Rating: 0

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.