A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

More Questions from The Relational Model and Normalization

• Any table that meets the definition of a relation is said to be in first normal form.
• In a relation, the order of the rows matters.
• Given the functional dependency R → S , R is called the determinant.
• In a relation, the rows are sometimes called "records."
• In a relation, the order of the columns does not matter.
• A relation has cells that hold multi-value entries.
• Relations are categorized into normal forms according to the referential integrity constraints that they have.
• A functional dependency is always an equation.
• A key is a group of one or more attributes that uniquely identifies a row.
• In a relation, the columns are sometimes called "attributes."

Discussion & Comments