Solved

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

Question 23

Multiple Choice

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions