3 votes 3 votes "If a relational schema is in BCNF then all redundancy based on functional dependency has been removed, although other types of redundancy may still exist" What are these other redundancies? Databases database-normalization databases + – vaishali jhalani asked Jan 8, 2017 vaishali jhalani 2.1k views answer comment Share Follow See 1 comment See all 1 1 comment reply Rahul Jain25 commented Jan 8, 2017 reply Follow Share These redundancies are because of multivalued dependencies that may exist. Redundancy that arise because of functional dependies are removed in BCNF but those bcoz of multivalued dependencies still exist. It is previous gate question and also on gateoverflow, you can check that also. 5 votes 5 votes Please log in or register to add a comment.
2 votes 2 votes Multi valued Redundancy exits. Arnab Bhadra answered May 24, 2017 Arnab Bhadra comment Share Follow See all 0 reply Please log in or register to add a comment.