Difference Between 3NF and BCNF

In this post, we will understand the difference between 3NF and BCNF.

3NF

• There shouldn’t be any transitive dependency.

• There shouldn’t be any non-prime attribute that depends transitively on a candidate key.

• It is not as strong as BCNF.

• It has high redundancy.

• The functional dependencies are already present in INF and 2NF.

• It is easy to achieve.

• It can be used to achieve lossless decomposition.

BCNF

• For any relation A->B, ‘A’ should be a super key of that specific relation.

• It is stronger than 3NF.

• The functional dependencies are present in 1NF, 2NF and 3NF.

• It has low redundancy in comparison to 3NF.

• The functional dependencies may or may not be preserved.

• It is difficult to achieve.

• It is difficult to achieve lossless decomposition using BCNF.

AmitDiwan

Published on 25-Mar-2021 06:30:48

• Related Questions & Answers
• Check which FD violates 3NF in a given relation and decompose R into 3NF(DBMS)
• Third Normal Form (3NF)
• Boyce–Codd Normal Form (BCNF)
• Explain BCNF with an example in DBMS
• Explain 3NF with an example in DBMS
• Difference between JCoClient and JCoDestination
• Difference between String and StringBuffer.
• Difference between StringBuffer and StringBuilder.
• Difference between C# and .Net
• Difference between Process and Thread
• Difference between Concurrency and Parallelism
• Difference between localhost and 127.0.0.1?
• Difference between Java and JavaScript.
• Difference between NodeJS and AngularJS
• Difference between Normalization and Denormalization