–1 votes –1 votes Every BCNF decomposition is A)Dependency preserving B)not a dependency preserving C)Need not be dependency preserving D)None of the above Databases bcnf docm bcnf-decomposition database-normalization + – vivekpinto07 asked Jun 19, 2016 vivekpinto07 2.5k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes While every BCNF Decomposition may yield Dependency Preservation, others may not. I m not able to suggest you an appropriate option. However the link mentioned under might just clear some of your doubts. Hope it Helps. Do refer it once. :) http://www.cs.sfu.ca/CourseCentral/354/zaiane/material/notes/Chapter7/node10.html Devshree Dubey answered Jun 19, 2016 Devshree Dubey comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes OPTION C BCNF need not be FD preserving always. It may be or may not be. Sohini answered Jun 19, 2016 Sohini comment Share Follow See all 0 reply Please log in or register to add a comment.
1 votes 1 votes C)Need not be dependency preserving Lizu answered Jun 25, 2016 Lizu comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Option C will be right option for it bcz every table in BCNF should not be in FDs preserving but it is not case of 3NF.This is very -very important difference in 3NF as well as BCNF. Paras Nath answered Dec 12, 2016 Paras Nath comment Share Follow See all 0 reply Please log in or register to add a comment.