1,034 views
1 votes
1 votes

Relation R (A,B,C,D,E,F)

Functional dependency:  ABC -->DEF,    BC-->EF,  EF-->D.

Decomposition: R1 (ABCDF), R2 (BCDE).  Is this decomposition lossy?

Is this decomposition preserve functional dependency?

Plz explain how to check functional dependency is preserved or not in decomposition.

 

Please log in or register to answer this question.

Related questions

2 votes
2 votes
2 answers
1
gatecrack asked Dec 10, 2018
581 views
Is minimal set of functional dependency for a functional dependency set is always unique???
0 votes
0 votes
1 answer
3
2 votes
2 votes
2 answers
4