1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

Boyce-Codd Normal Form (BCNF)

By

A businessman at work
Visage/Stockbyte/Getty Images

Definition: A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a candidate key. (See the links in the box at right for definitions of determinant and candidate key.)

Also Known As: BCNF

Examples: Conisder a database table that stores employee information and has the attributes employee_id, first_name, last_name, title. In this table, the field employee_id determines first_name and last_name. Similarly, the tuple (first_name, last_name) determines employee_id.

  1. About.com
  2. Technology
  3. Databases
  4. Design
  5. Boyce-Codd Normal Form (BCNF)

©2014 About.com. All rights reserved.