Question

Given the relations:
STUDENT (SID, StudentName, Major, AdvisorID)
ADVISOR (AdvisorID, AdvisorName, Office, Phone)
such that each student is assigned to one advisor, which of the following is true?
A) SID is both a primary key and a foreign key.
B) AdvisorName is a determinant.
C) AdvisorID is a foreign key.
D) Phone is a candidate key.
E) Major is a candidate key.

Answer

This answer is hidden. It contains 1 characters.