in Databases
616 views
1 vote
1 vote

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/

in Databases
616 views

1 comment

Yes Dependency preserved. D-->A we can derive by combining AB,BC and CD via transitive dependency.
0
0

1 Answer

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

4 Comments

Thanks
0
0
Can u pls explain in details how to check for it ?
0
0
D -> A preserve. via indirect FD
0
0

Dependency is preserved. Check this link 

https://gateoverflow.in/741/gate2001-2-23

0
0