A corrected 5NF definition for relational database design

✍ Scribed by Millist W. Vincent

• Publisher: Elsevier Science
• Year: 1997
• Tongue: English
• Weight: 994 KB
• Volume: 185
• Category: Article
• ISSN: 0304-3975
• DOI: 10.1016/s0304-3975(97)00050-9

✦ Synopsis

In this paper, the adequacy of fifth normal form (5NF) in relational database design is investigated. It is shown that 5NF is inadequate because it does not generalise fourth normal form (4NF) and because it is equivalent to the very stringent requirement that every attribute is a key, a requirement that is effectively impossible to satisfy in practical database design. By restricting the join dependencies (JDs) in the set of constraints to those that do not have superfluous components, the definition of 5NF is then changed to a new normal form, called reduced fifth normal form (SNFR), and it is shown that 5NFR generalises 4NF. It is also shown that SNFR is a strictly weaker condition than projection-join normal form (PJ/NF), the other normal form that has been proposed for JDs.