DBMS Notes

Boyce Codd Normal Form (BCNF)

BCNF is extension of 3NF. It is stricter than 3NF. According to codd normal form (BCNF),

1. For BCNF, the table should be in 3NF.

2. And for every FD, L.H.S should be a candidate key or super key.

Example: Let’s assume the following student table

The above table holds the following Candidate keys and FD’s

  • Candidate key = {RollNo, ID_Card}
  • FD = {RollNo → Name, RollNo→ ID_Card,  ID_Card → age, ID_Card → RollNo}

As the L.H.S of all above functional dependencies contains a candidate key or super key. So, the above table is in BCNF.

Help Other’s By Sharing…

Contact Us

Burewala, Vehari, Punjab, Pakistan

cstaleem1@gmail.com

Website: CStaleem.com

Pin It on Pinterest