3 votes 3 votes R(A, B, C, D) FD: B->C, D->A is the following decomposition in BCNF? R1(B, C), R2(A, D), R3(C, D) Databases databases database-normalization normal bcnf-decomposition bcnf + – aditi19 asked Nov 29, 2018 aditi19 1.1k views answer comment Share Follow See all 24 Comments See all 24 24 Comments reply Show 21 previous comments Shubhgupta commented Nov 29, 2018 reply Follow Share if suppose we have dependency A->B, B->C, C->D and D-> A then according to this A,B,C and D all are the keys. and we don't require any extra decomposition. So it means above statement should be incorrect. 0 votes 0 votes Lakshman Bhaiya commented Nov 29, 2018 reply Follow Share Yes, it dependents on the decomposition. 0 votes 0 votes anjali007 commented Nov 30, 2018 reply Follow Share @aditi19 yes... 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes No due to lossy the decomposion is not in BCNF. for decomposition to be a loss less the common attribute between the decompossed relation must be the candidate key of any of the decompossed relation. prashant dubey answered Apr 27, 2019 prashant dubey comment Share Follow See all 0 reply Please log in or register to add a comment.