298 views

1 Answer

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 .

Related questions

1 votes
1 votes
1 answer
1
Mk Utkarsh asked Jan 12, 2018
978 views
1 votes
1 votes
2 answers
2
Tuhin Dutta asked Dec 8, 2017
595 views
$R(X,Y,Z,W) is\ decomposed\ into \\ R_1(X,Y)\\ R_2(Y,Z)\\ R_3(Y,W).\\The\ FDs\ are\ :\\ X - Y,\\ Z->Y,\\ Y->W \\ Find\ whether\ the\ decomposition\ is\ lossless\ or\ ...
3 votes
3 votes
4 answers
4