Made Easy Test Series

Question

Consider a relation R(A,B,C,D,E) and functional dependencies:

F= (AC->B, C->D, A->E, C->B)

Relation R is decomposed into R1(A,B,C) and R2(C,D), then which of the following is correct about the decomposition?

(a) Lossless and dependency preserving

(b) Lossy and dependency preserving

© Lossless and not dependency preserving

(d) Not Lossless and not dependency preserving

Comments

Oh how I missed that, attribute E is not preserved after decomposing. This decomposition is lossy.

Sorry for the mistake.

---

ya even I made the same mistake during exam..this reason just clicked me now :P

---

even I did the same mistake - _-