Multivalued dependencies and a new normal form for relational databases

0
191

Authors: Ronald Fagin

Tags: 1977, conceptual modeling

A new type of dependency, which includes the well-known functional dependencies as a special case, is defined for relational databases. By using this concept, a new (“fourth”) normal form for relation schemata is defined. This fourth normal form is strictly stronger than Codd’s “improved third normal form” (or “Boyce-Codd normal form”). It is shown that every relation schema can be decomposed into a family of relation schemata in fourth normal form without loss of information (that is, the original relation can be obtained from the new relations by taking joins).

Read the full paper here: https://dl.acm.org/doi/10.1145/320434.320436