717 views
1 votes
1 votes

Consider R(B->D, C->B, D->A)

Consider the following 2 decompositions : R1(ABC) and R2(CD).

  1. Whether this is a lossless decomposition?
  2. Whether this is a lossless decomposition?

2 Answers

0 votes
0 votes
yes it is lossless decomposition because in both relation C attribute is common which is also key relation (ABCD).so it is lossless.

but it not dependency preservation, due to B->D and D->A i am not able to preserve

Related questions