0 0 votes Does BCNF completely eliminate redundancy? Databases + – mehul vaidya 922 views answer comment Share Follow Print See 1 comment 1 1 comment reply Sankalp20894 commented Jul 2, 2018 reply Follow flag BCNF eliminate single level functional dependency but it can't remove multivalued dependency. 0 0 replyShare Please log in or register to add a comment.
2 2 votes BCNF completely eliminate redundancy over functional dependency . Its not free from redundancy over multivalued dependency. So your statement is wrong . abhishekmehta4u answered Jul 2, 2018 abhishekmehta4u comment Share Follow See all 3 Comments 3 3 Comments reply mehul vaidya commented Jul 2, 2018 reply Follow flag is it possible for you to explain what is "Redundancy over FD" . Also is relation with just two attribute has no redundancy? (I know relation with two attribute is always in BCNF) Thanks you 1 1 replyShare abhishekmehta4u commented Jul 3, 2018 reply Follow flag Yes you are right . With two attribute the relation is in BCNF . and it is free from redundancy over FD. 0 0 replyShare hitendra singh commented Nov 2, 2018 reply Follow flag can you tell about compound candidate key and simple candidate key ? 0 0 replyShare Please log in or register to add a comment.
1 1 vote BCNF is optimal form ,it removes redundancy nearly 0% but not completely. Anil Ji answered Jul 2, 2018 Anil Ji comment Share Follow 0 reply Please log in or register to add a comment.
