1 votes 1 votes Consider the relation $R(X Y Z)$ has the following tuples X Y Z 1 2 3 1 2 4 3 2 1 _________ tuples in the result of following relational algebra expression $(\underset{X,Y}\pi R ) \underset{R,Y < S,Y}\bowtie (\underset{S(X,Y)}\rho (\underset{Y,Z}\pi R))$ Databases databases natural-join + – Registered user 7 asked Feb 5, 2016 retagged Aug 5, 2017 by Arjun Registered user 7 2.6k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
3 votes 3 votes 1 2 2 3 1 2 2 4 3 2 2 3 3 2 2 4 harsh04 answered Feb 5, 2016 harsh04 comment Share Follow See all 2 Comments See all 2 2 Comments reply Registered user 7 commented Feb 5, 2016 reply Follow Share but xy means we have to consider in R relation only right...12,32 possible in R..only 2 rows are printed is it correct 0 votes 0 votes Registered user 7 commented Mar 28, 2016 reply Follow Share yes i feel that 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Initially ∏y,z(R) => Y Z this table is renamed as S(X,Y) = > X Y 2 3 2 3 2 4 2 4 2 1 2 1 Finally ∏x,y(R) natural join ∏x,y (S) 1 2 2 3 1 2 2 4 3 2 2 3 3 2 2 4 By eliminating duplicates So the result is 4 tuples shivanisrivarshini answered Apr 14, 2016 shivanisrivarshini comment Share Follow See all 0 reply Please log in or register to add a comment.