Database Reference
In-Depth Information
and the original table must be able to be reconstructed from the tables into which it has
been broken down without any loss of data.
Following tables shows data that is not fit to 5NF. Decomposing is required to break the
relation into three distinct relations.
Following figures show, decomposition of a single three-field composite primary key (Pro-
jectDescription, Employee, Manager) table to three semi-related tables, each containing
two-field composite primary keys.