
- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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
Advertisements