Which key is used to establish a relationship between two relational database tables?
Options
-
A.
Primary key
-
B.
Foreign key
-
C.
Candidate key
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
B.
Foreign key
Detailed Explanation
- Foreign key: An attribute or set of attributes in one table that references a candidate key, commonly the primary key, of another or the same table.
- It establishes relationships between tables.
- It helps maintain referential integrity.
OOps! You are currently offline.