You are here
Fill in the blank:
_________ is a non-key attribute, whose values are derived from the
primary key of some other table.
(a) Primary Key
(b) Foreign Key
(c) Candidate Key
(d) Alternate Key
Answer:
Checking the options:
- (a) Primary Key - It is used to uniquely identify the tuples in a relation.
- (b) Foreign Key - It is used to represent the relationship between two tables/relations and its value is derived from the primary key of some other table.
- (c) Candidate Key - refers to the set of all attributes which can uniquely identify records in a relation.
- (d) Alternate Key - It is a candidate key which has not been selected to be the primary key.
So, the correct answer is (b).
