Boycee-Codd Normal Form (BCNF)

Boycee-Codd Normal Form (BCNF)

The original definition of 1NF was inadequate in some situations. It was not satisfactory  for the tables: That had multiple candidate keys. Where the multiple candidate keys were composite Where the multiple candidate keys overlapped  (had atleast one attribute to common)   Therefore, a new normal form, the BCNF was introduced. You must understand that [...]