1 votes 1 votes Databases databases natural-join made-easy-test-series cbt-2019 + – singh chetan asked Jan 28, 2019 retagged Mar 3, 2019 by ajaysoni1924 singh chetan 810 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply raahul commented Jan 28, 2019 reply Follow Share 800 I think 0 votes 0 votes singh chetan commented Jan 28, 2019 reply Follow Share yes ,explanation please?? 0 votes 0 votes raahul commented Jan 28, 2019 reply Follow Share When you will naturally join S and T both have E as common. As for S E is simple candidate key and will have unique values and in T E can take same values as it not simple. So,maximum we can get by joining is 80 tuples. Now, Joining with table R.as A is candidate key it will have unique value and in previous S join T there aslo A will have unique value, So, maximum tuple we will get will be 80. Now,Joining these three R,S,T with U common attribute will be D,G both are non-key so,maximum we get when both D,G are same for every table. So,80*10=800. 2 votes 2 votes singh chetan commented Jan 28, 2019 reply Follow Share got it,thank u.. 0 votes 0 votes Please log in or register to add a comment.