1 votes 1 votes Consider R(B->D, C->B, D->A) Consider the following 2 decompositions : R1(ABC) and R2(CD). Whether this is a lossless decomposition? Whether this is a lossless decomposition? Databases databases dependency-preserving + – Balaji Jegan asked Jul 9, 2018 Balaji Jegan 717 views answer comment Share Follow See 1 comment See all 1 1 comment reply Prateek Raghuvanshi commented Jul 9, 2018 reply Follow Share yes it is lossless decomposition because in both relation C attribute is common which is also key relation (ABCD).so it is lossless. 0 votes 0 votes Please log in or register to add a comment.
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 Shaik Masthan answered Jul 9, 2018 Shaik Masthan comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Lossless and not dependency preserving abhishekmehta4u answered Jul 9, 2018 abhishekmehta4u comment Share Follow See all 0 reply Please log in or register to add a comment.