2 votes 2 votes The relation R (A B C D E) is given with following functional dependencies A->BC CD->E B->D E->A CANDIDATE KEYS ARE-(A,E,CD,BC) IF WE DECOMPOSE IT INTO BCNF, WILL THIS BE FUNCTIONAL DEPENDENCY PRESERVING??? Databases database-normalization databases + – sushmita asked Dec 28, 2016 • retagged Aug 5, 2017 by Arjun sushmita 1.3k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 3 votes 3 votes NO, it's not preserving dependency CD->E. because, on decomposition schema R1={A,B,C,E},R2={B,D}. sachin! answered Dec 28, 2016 • selected Dec 28, 2016 by sushmita sachin! comment Share Follow See 1 comment See all 1 1 comment reply sushmita commented Dec 28, 2016 reply Follow Share thanx i was also getting the same answer but the soln was wrongly given as FD preserving. Thanx for confirmation. :-) 0 votes 0 votes Please log in or register to add a comment.
