____________ refers to the attribute that can uniquely identify tuples within the relation.
(A) Foreign key
(B) Consolidate key
(C) Alternate Key
(D) Primary key
Answer:
Checking the options
- (A) Foreign key - It is used to represent the relationship between two tables/relations.
- (B) Consolidate key - It is not a valid key in the relational database.
- (C) Alternate Key - It is a candidate key which has not been selected to be the primary key.
- (D) Primary key - It is used to uniquely identify the tuples in a relation.
From the above explanation, we understand that the primary key is the attribute which can uniquely identify tuples within a relation.
So, the correct answer is (D)
