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.

Question

Quizplus · Accepted Answer

AdvisorID in the STUDENT table is a foreign key that references AdvisorID in the ADVISOR table, establishing the relationship between students and their advisors.

Given the Relations: STUDENT (SID,StudentName,Major,AdvisorID)