Register

referential Integrity

• retagged by
756 views

1 Answer

Best answer
3 votes
3 votes
c is foreign key referring to A, means if ( 4,3) is deleted , 4 will not be in C(foreign key) so tuple (2,4), (3,4), (6,4) will be deleted then , now , Primary key value 2, 3 ,6 deleted so they also will not be in C as foreign key ... so tuple (5,2) , (7,2) are removed now in similar way 5 , 7 are deleted so (9,5) also deleted so total additional 6 tuples will be deleted
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
3
ankitgupta.1729 asked Dec 16, 2017
1,285 views
Referential Integrity
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential integrity constraint:- (A) 9 and 0 (B) 9 and 9 (C) 9+100 and 0 (D) 9*100 and 9
Consider the join of a relation R with a relation S. If R has 100 tuples and S has 9 tuples then the maximum and minimum sizes of the join respectively under referential ...
User Avatar
Link Copied!