BCNF – Boyce-Codd Normalized Form (3.5)

• A database table is in BCNF if and only if there are no non-trivial functional dependencies of attributes on anything other than a superkey of a candidate key

Task Table

Superkey - that in all relations assigned to that variable, there are no two distinct tuples (rows) that have the same values for the attributes in this set

Candidate Key - A candidate key is a column, or set of columns, in a table that can uniquely identify any database record without referring to any other data

In this example I can derive the TaskID (Part of the Key) from the VendorID (Not a Key) Hence it is not BCNF