Question

Consider the relation R (ABCDEFGH) suppose following FD's hold F= {A?BC, F?A, CD?E, B?D,. A?FGH} state whether the following
composition or Lossy. R1= (ABDF), R2= (ACDEG), R3= (AGH).
A?FGH} State whether the following decomposition of relation R is the Loss Less Join decomposition or lossy R1=(ABDF),R2=(ACDEG),R3=(AGH).
​

Answer 1

Explanation:

Consider the relation R (ABCDEFGH) suppose following FD's hold F= {A?BC, F?A, CD?E, B?D,. A?FGH} state whether the following

composition or Lossy. R1= (ABDF), R2= (ACDEG), R3= (AGH).

A?FGH} State whether the following decomposition of relation R is the Loss Less Join decomposition or lossy R1=(ABDF),R2=(ACDEG),R3=(AGH).