Fourth normal form (4NF) is a normal form used in database normalization. Introduced by Ronald Fagin in 1977, 4NF is the next level of normalization after Boyce–Codd normal form (BCNF). Whereas the second, third, and Boyce–Codd normal forms are concerned with functional dependencies, 4NF is concerned with a more general type of dependency known as a multivalued dependency. A Table is in 4NF if and only if, for every one of its non-trivial multivalued dependencies X Y, X is a superkey—that is, X is either a candidate key or a superset thereof.
Read more about Fourth Normal Form: Multivalued Dependencies, Example, 4NF in Practice
Famous quotes containing the words fourth, normal and/or form:
“What, to the American slave, is your Fourth of July? I answer: A day that reveals to him, more than all other days in the year, the gross injustice and cruelty to which he is the constant victim. To him your celebration is a sham.”
—Frederick Douglass (c.1817–1895)
“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)