306 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.

 

1 Answer

Best answer
1 votes
1 votes

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

0 votes
0 votes
0 answers
1
Overflow04 asked Nov 29, 2022
318 views
How to identify many to many relationship.Can R2 be one to one.
0 votes
0 votes
0 answers
2
ykrishnay asked Sep 6, 2022
534 views
which is best book for DBMS korth or navathe ?since i know that both book is great but i wanted to follow 1 particular book that is easy to understand and simple language...
0 votes
0 votes
0 answers
3
go_editor asked Mar 27, 2020
232 views
In a relational schema, each tuple is divided in fields called :RelationsDomainsQueriesAll the above