0 votes 0 votes Sanjay Sharma asked May 21, 2018 edited May 21, 2018 by Sanjay Sharma Sanjay Sharma 444 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes Option D is right. abhishekmehta4u answered May 21, 2018 abhishekmehta4u comment Share Follow See all 8 Comments See all 8 8 Comments reply Sanjay Sharma commented May 21, 2018 reply Follow Share why R1(BCD) is in BCNF and not only in 3NF 0 votes 0 votes abhishekmehta4u commented May 21, 2018 reply Follow Share Only trivial fd is in relation R1(BCD).SO IT IS IN BCNF 1 votes 1 votes Sanjay Sharma commented May 26, 2018 reply Follow Share BCD has f.d BC->CD (via AB->CD and C->A) which is not trivial and what will be ans of next 0 votes 0 votes abhishekmehta4u commented May 26, 2018 reply Follow Share Option c is right. 0 votes 0 votes Sanjay Sharma commented May 26, 2018 reply Follow Share how lossy their intersection is a superkey in second relation 0 votes 0 votes Sanjay Sharma commented May 26, 2018 reply Follow Share and dependency also preserved since AB->CD and C->A can give BC->CD which is present in CBD and from BC->CD and C->A we can get AB->CD 0 votes 0 votes abhishekmehta4u commented May 26, 2018 reply Follow Share Sorry wrote mistake. Option d is right.we can not derive functionl dependency AB-->CD. 0 votes 0 votes Sanjay Sharma commented May 26, 2018 reply Follow Share why dependency is not preserved can't we do like this AB->CD and C->A can give BC->CD which is present in CBD and from BC->CD and C->A we can get AB->CD 0 votes 0 votes Please log in or register to add a comment.