0 votes 0 votes Consider the relation r1(P, Q, R) and r2(R, U, V) with primary keys R and U respectively. The relation r1 contains 1500 tupples and r2contains 2000 tupples. The maximum size of the join is: Chirag arora asked Dec 6, 2017 Chirag arora 445 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply Ashwin Kulkarni commented Dec 6, 2017 reply Follow Share 2000 tuples. 0 votes 0 votes joshi_nitish commented Dec 6, 2017 reply Follow Share @Ashwin join could have max of 2000 tupples. 0 votes 0 votes Anu007 commented Dec 6, 2017 reply Follow Share it will be 2000 i think you took keys wrongly 0 votes 0 votes Ashwin Kulkarni commented Dec 6, 2017 reply Follow Share thankyou it will be 2000. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes 2000 tuples. The relation r1(P,Q,R) has primary key R i.e.,we have 1500 unique value of R in r1. while relation r2(R,U,V) has 2000 tuple with U as key i.e. it may contain duplicate value of R. Abhishek Kumar Singh answered Dec 6, 2017 Abhishek Kumar Singh comment Share Follow See all 0 reply Please log in or register to add a comment.
