Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 6 of 91

Relational Database and SQL — Question 6

Back to all questions
6
Question

Question 6

Assertion (A): A foreign key is an attribute whose value is derived from the primary key of another relation.

Reasoning (R): A foreign key is used to represent the relationship between tables or relations.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true and R is the correct explanation of A.

Explanation
A foreign key is a non-key attribute whose value is derived from the primary key of another table in a database. It references the primary key in another table, thereby establishing a relationship between the two tables.