626 views
1 votes
1 votes

R(ABCD)

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

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

Dependency is preserved or Not ?

Source : http://www.gatecrack.in/following-decomposition-dependency-preserving-not/

1 Answer

2 votes
2 votes
No,dependency is not preserved because FD D->A is not preserved if relation is decomposed as given.

Related questions

1 votes
1 votes
3 answers
2
ushamya asked Jun 3, 2019
918 views
R(A,B,C) is a relation.Which of the following don't have dependency preserving BCNF decomposition?A->B, B->CA->B,B->C,C->AAB->C,C->ANone of these
0 votes
0 votes
1 answer
4
night_fury asked Sep 23, 2018
760 views
The below decomposition is lossless or lossy and also dependency preserving or not?