Fifth normal form (5NF), also known as project-join normal form (PJ/NF) is a level of database normalization designed to reduce redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships. A table is said to be in the 5NF if and only if every join dependency in it is implied by the candidate keys.
A join dependency *{A, B, … Z} on R is implied by the candidate key(s) of R if and only if each of A, B, …, Z is a superkey for R.
Read more about Fifth Normal Form: Example
Famous quotes containing the words normal and/or form:
“The normal present connects the past and the future through limitation. Contiguity results, crystallization by means of solidification. There also exists, however, a spiritual present that identifies past and future through dissolution, and this mixture is the element, the atmosphere of the poet.”
—Novalis [Friedrich Von Hardenberg] (1772–1801)
“One of the many to whom, from straightened circumstances, a consequent inability to form the associations they would wish, and a disinclination to mix with the society they could obtain, London is as complete a solitude as the plains of Syria.”
—Charles Dickens (1812–1870)