$2$uestion $16$

iven the relations:

TUDENT $($SID$,$ StudentName, Major, AdvisorID$)$

DVISOR $($AdvisorID$,$ AdvisorName, Office, Phone$)$

uch that each student is assigned to one advisor, which of the following is true?

Major is a candidate key.

SID is both a primary key and a foreign key.

AdvisorName is a determinant.

Phone is a candidate key.

AdvisorID is a foreign key.

Question $17$

$0\mathrm{.}5p$

F$4$

F $5$

F$6$

F$7$

F$8$