#Normalization #DBMS #BCNF #4NF Boyce–Codd normal form (BCNF) & 4NF in DBMS | Boyce Codd normal form
Channel: Tech Educators
Date: 25/03/2021

#Normalization #DBMS #BCNF #4NF Boyce–Codd normal form (BCNF) & 4NF in DBMS | Boyce Codd normal form

What is BCNF?
Boyce–Codd normal form (or BCNF or 3.5NF) is a normal form used in database normalization. It is a slightly stronger version of the third normal form (3NF). ... 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.

4NF: Fourth normal form (4NF) is a level of database normalization where there are no non-trivial multivalued dependencies other than a candidate key. It builds on the first three normal forms (1NF, 2NF and 3NF) and the Boyce-Codd Normal Form (BCNF). the table should not have any Multi-valued Dependency.

Do like, share, comment and subscribe my channel.