0 votes 0 votes R(ABCDEG) and FD sets {AB->C, AC->B, AD->E, B->D, BC->A, E->G} D=( ABC, ACDE, ADG) Databases databases lossless-join + – smartmeet asked Jan 27, 2017 smartmeet 316 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes ABC intersection ACDE=AC AC+={A,B,C,D,E,G} So,ABC and ACDE can be joined as ABCDE Now ABCDE inter ADG=AD AD+={A,D,E,G} So,they can now be joined as ABCDEG.Hence Lossless. Basically,if R1 inter R2=R1 or R2 then R1 and R2 can be joined . Purvi Agrawal answered Mar 12, 2017 Purvi Agrawal comment Share Follow See all 0 reply Please log in or register to add a comment.