Question

An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

(a) Candidate

(b) Primary

(c) Super

(d) Sub

I had been asked this question during an interview for a job.

I would like to ask this question from Keys in section The Relational Model of Database Management

Answer 1

The correct choice is (b) Primary

The best I can explain: The primary key has to be referred in the other relation to form a foreign key in that relation.