Sel doubt

Question

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.

 

Comments

what you want to conclude @Shaik Masthan

---

@Shaik Masthan I think  it is Lossless and dependency EF-->D not preserved.

---

@Shivam Kasat

the conclusion is

common attributes are need to be candidate key or super key