Is the Following Decomposition is Dependency Preserving or Not ?

R(ABCD)

F={  A→B, B→C, C→D, D→A }

Now Decompose this into D={ AB, BC, CD }

Dependency is preserved or Not ?

Ans :

No,dependency is not preserved because FD D→A is not preserved if relation is decomposed as given .

 

Leave a Reply

Your email address will not be published. Required fields are marked *