Question

$AD\to E,AB\to C,B\to D,AC\to B,BC\to A,E\to F$
$\text{the decomposition of R into}{R}_1\left(ABDE\right),R_2\left(ABC\right)and{R}_3\left(EF\right)is$

Answer 1

Option (a)

• R(A, B, C, D, E, F)

$R_1\left(ABCE\right)$	$R_2\left(ABC\right)$
$B\to D$ $AD\to E$	$AB\to C$ $BC\to A$ $AC\to B$

So, it is Dependency Preserving.

• It is lossless join because in every relation there is