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) Phone is a candidate key. c) AdvisorID is a foreign key. d) Major is a candidate key. e) AdvisorName is a determinant.

Answer 1

Answer:

C. AdvisorID is a foreign key

Explanation:

A foreign key is a field in a table (of databases that are cross related with one another) that is a primary key in/of another table. It is a link between the information in two tables of databases.

AdvisorID in the case of this question is a foreign key in the ADVISOR database but is a primary field in the STUDENT database since each student is meant to have a be assigned to an Advisor which is the main purpose of the

Cheers.