fifth normal form
a relation schema
is in fifth normal form (5NF) with respect to a set
of functional, multivalued, and join dependencies if, for every nontrivial join dependency
in
(that is, implied by
), every
is a superkey of
.
[cite:;from @elmasri_db_2015 chapter 14.7 join dependencies and fifth normal form]
[cite:;from @elmasri_db_2015 chapter 14.7 join dependencies and fifth normal form]
5nf generalizes 4nf to more than 2 pairs of multivalued dependencies in the key of the original relation.
dealers represent companies, and sell their products
the following schema is appropriate:
the following schema is appropriate:
- company-dealers (company, dealer)
- product-dealers (product, dealer)
- company-products (product, company)
- sales (product, company, dealer)