Question

Define boyce codd normal form how does it differ from 3nf why is it

Answer 1

卄乇ㄥㄥㄖ

A relation is in 3NF if it is in 2NF and no non-prime attribute depends on the primary key. In other words, a relationR is in 3NF if for each functional dependency X . A in R at least one of the following conditions are met: X is a key or superkey in R.

A relation R is in BCNF if it is in 3NF and for each functional dependency X ⟶ A in R, X is a key or superkey in R. In other words, the only difference between 3NF and BCNF is that in BCNF it is not present the second condition of the3NF.

Answer 2

${\huge {\mathfrak {Answer :-}}}$

➡️ Boyce codd normal form

Boyce–Codd normal form is a normal form used in database normalization. It is a slightly stronger version of the third normal form. BCNF was developed in 1975 by Raymond F. Boyce and Edgar F. Codd to address certain types of anomalies not dealt with by 3NF as originally defined.