in Databases
196 views
2 votes
2 votes

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.

 

in Databases
by
196 views

2 Comments

whats the answer you got for this? Thanks
1
1
How to figure out which table has FK and which table has PK?
0
0

1 Answer

1 vote
1 vote
Best answer

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.

selected by

Related questions