According to the wikipedia example, the following example is not bcnf because there are overlapping candidate keys (name and job, name and contractor)
Name Work Contractor
John Plumber Plumber industries
Ryan Plumber Plumber industries
Ryan Elektrician Electro industries
However, is this table also not in 2NF? Keep in mind that the name and work constitute the primary key, the contractor can only be obtained from the work, why should the database be divided?
If my statement is true, can someone provide me with a (easy) example of a database that is not in BCNF but is 2NF?
source
share