in Databases
1,494 views
6 votes
6 votes

Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are 

$F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$

Relation $R$ is decomposed into  $R_{1}\left ( A,B,C \right )$ and $R_{2}\left ( C,D \right )$

Then Is it a lossless decomposition?


I am getting doubt, how it can be not lossless decomposition?

in Databases
by
1.5k views

1 comment

It cannot be lossless because all the attributes are not present in this decomposition.
1
1

5 Answers

0 votes
0 votes
This is not a loseless decomposition since attributes are not preserved. Here, E is not present.