0 votes 0 votes 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: 9 and 0 9 and 9 9+100 and 0 9*100 and 9 Databases databases joins referential-integrity + – Priyendu Mori asked Dec 31, 2017 Priyendu Mori 486 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes B 9 and 9 Bcoz of referential integrity at Max only 9 tuples can be matched in join Aarti3001 answered Dec 31, 2017 Aarti3001 comment Share Follow See 1 comment See all 1 1 comment reply sethi commented Apr 11, 2018 reply Follow Share @Aarti3001 why it is not 100 and 100 although it is not in option? 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes ans should be 9*100 and 0 . same question slight modifications. https://gateoverflow.in/1471/gate1999-1-18-isro2016-53 Harshitkmr answered Nov 14, 2019 Harshitkmr comment Share Follow See all 0 reply Please log in or register to add a comment.