in Databases
800 views
0 votes
0 votes
Given  relation and the FDs applicable on it. How to check whether a given decomposition is lossless and dependency preserving?

I know that for lossless we can easily check by seeing if the common attribute in the decomposed relation is a key in one of the relations. Will this be applicable is the common attribute is a proper subset of a key in one relation. ?

I dont know how to check for dependency preserving.. can someone please explain the steps for it ?
in Databases
by
800 views

1 Answer

0 votes
0 votes

Will this be applicable is the common attribute is a proper subset of a key in one relation. ?

No. Common attribute must be a KEY.
 

I dont know how to check for dependency preserving.. can someone please explain the steps for it ?

Proper steps you can see in DBMS text. If you practice, in GATE you can see each decomposed relation and what all dependencies they satisfy. Then, also consider transitive dependency and see if these cover all the dependencies of original relation. 

by

1 comment

For Dependency Preserving Steps wice answer pls see to it

https://gateoverflow.in/3371/gate2008-it-61?show=66682#a66682
0
0