GATE ACADEMY TEST SERIES

Question

Under a relational database if table A has a foreign key constraint referencing to another table B, then

 

---

Each tuple in A is related to zero or one tuple of B.

Each tuple in A is related to exactly one tuple of B.

Each tuple of A is related to zero or more tuple of B.

None of these.

 

Comments

whats the answer you got for this? Thanks

---

How to figure out which table has FK and which table has PK?

Answer 1

The answer is option “b” Each tuple in A is related to exactly one tuple of B. 

as per the referential integrity constraint, a foreign key is the subset of the primary key of another relation.