Boyce-Codd Normal Form (BCNF)

Posted By on October 10, 2014


Download PDF
Other Functional Dependencies
Multivalued Dependencies

Boyce-Codd Normal Form

:
BCNF is an extension of Third Normal Form in strict way. BCNF states that

For any non-trivial functional dependency, X → A, then X must be a super-key.

In the above depicted picture, Stu_ID is super-key in Student_Detail relation and Zip is super-key in ZipCodes relation. So,

Stu_ID → Stu_Name, Zip

And

Zip → City

Confirms, that both relations are in BCNF.

Other Functional Dependencies
Multivalued Dependencies

Download PDF

Posted by Akash Kurup

Founder and C.E.O, World4Engineers Educationist and Entrepreneur by passion. Orator and blogger by hobby

Website: http://world4engineers.com