KnowledgeBoat Logo

Computer Science

Which of the following statements is FALSE about keys in a relational database?

  1. Any candidate key is eligible to become a primary key.
  2. A primary key uniquely identifies the tuples in a relation.
  3. A candidate key that is not a primary key is a foreign key.
  4. A foreign key is an attribute whose value is derived from the primary key of another relation.

Relational Database

3 Likes

Answer

A candidate key that is not a primary key is a foreign key.

Reason — A candidate key that is not chosen as the primary key remains a candidate key and is not automatically a foreign key.

Answered By

3 Likes


Related Questions