0 votes 0 votes When we do natural join say between R1(A,B,C) and R2(A,B,D) we get new Relation as ---> R(A,B,C,D) Say if we do Theta join using a Predicate P then the result will be ----> R(A,B,C,A,B,D) Am i right? Databases databases natural-join + – Na462 asked May 17, 2018 Na462 450 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes Yes you are right when we take natural join ,then there will a condition of equality as your case R1(A,B,C)$\Join$R2(A,B,D)=R(ABCD) you can write like this only when AB of R1 =AB of R2 (keep in mind relation should be lossless and depencies should be preserve) And second case you right because condition over can be anything so you have to keep all entities of both relation. Prateek Raghuvanshi answered May 22, 2018 Prateek Raghuvanshi comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes YOU ARE RIGHT In natural join common column are ellimenated . R1(ABC) join R2(ABD)= R12(ABCD) In conditional join (theta) R1 have m column and R2 have n column .then total number of column is m+n. R1(ABC) theta join R2(ABD)= R12(ABCABD) abhishekmehta4u answered May 22, 2018 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.