876 views
0 votes
0 votes
A relation R (ABCDE) and functional dependency set F={AB->CDE , C->D, E->A} and is decomposed into BCNF.

Lossless?

Lossy?

Dependency preserving?

Not dependency preserving?

1 Answer

1 votes
1 votes
$AB\rightarrow CDE$

$C\rightarrow D$

$E \rightarrow A$

$Candidate \ keys = \left \{ AB , EB \right \}$

For making above relation BCNF,

$\left ( A,B,D \right )$ , $AB \rightarrow D$

$\left ( A,B,C \right )$ , $AB \rightarrow C$

$\left ( C,D \right ), C \rightarrow D$

$\left ( E,A \right ), E \rightarrow A \ $

lossless but dependency $AB \rightarrow E$ is not preserved
edited by

Related questions

0 votes
0 votes
1 answer
3
0 votes
0 votes
1 answer
4
night_fury asked Sep 23, 2018
763 views
The below decomposition is lossless or lossy and also dependency preserving or not?