803 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 ?

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. 

Related questions

2 votes
2 votes
2 answers
2
gauravalgo asked Jun 21, 2015
755 views
R={ABCDEG}AB->CAC->BAD->EB->DBC->AE->Gfor the following relations {AB , BC ,ABDE, EG}
0 votes
0 votes
1 answer
3
night_fury asked Sep 23, 2018
763 views
The below decomposition is lossless or lossy and also dependency preserving or not?