#Normalization​ #DBMS​ #3NFVsBCNF​ ​ #Boyce–Codd normal form (BCNF) 3NF Vs BCNF in DBMS
Channel: Tech Educators
Date: 25/03/2021

#Normalization​ #DBMS​ #3NFVsBCNF​ ​ #Boyce–Codd normal form (BCNF) 3NF Vs BCNF in DBMS 
What is the difference between 3NF and BCNF (Boyce–Codd normal form)?
Key Differences Between 3NF and BCNF
3NF states that no non-prime attribute must be transitively dependent on the candidate key of the relation. On the other hands, BCNF states that if a trivial functional dependency X is to Y exist for a relation; then X must be a super key.
3NF can be obtained without sacrificing the dependency of relation. However, dependency may not be preserved while obtaining BCNF.
3NF can be achieved without loosing any information from the old table whereas, while obtaining BCNF we may loose some information from the old table.
Conclusion:
BCNF is much restrictive than 3NF which help in normalizing the table more. The relation in 3NF has minimum redundancy left which is further removed by the BCNF.

Do Like , share, comment and subscribe my channel.