1 votes 1 votes After mapping an ER diagram relationship to Relational model using the set of rules for 1:n,m:n etc,will the achieved tables will always be in BCNF ? Databases er-diagram databases + – suchismith roy asked Sep 18, 2016 • retagged Jun 4, 2017 by Arjun suchismith roy 495 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
2 votes 2 votes An ER diagram is basic representation of the relationship. BCNF is a very specialized concept. WOuld every time ER diagram translate into BCNF, there would be no need of database system :) So, I think answer is no. Sushant Gokhale answered Sep 18, 2016 Sushant Gokhale comment Share Follow See all 0 reply Please log in or register to add a comment.