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:
“The fourth day of Christmas,
My true love sent to me
Four colly birds,”
—Unknown. The Twelve Days of Christmas (l. 13–15)
“We have been weakened in our resistance to the professional anti-Communists because we know in our hearts that our so-called democracy has excluded millions of citizens from a normal life and the normal American privileges of health, housing and education.”
—Agnes E. Meyer (1887–1970)
“[With the Union saved] its form of government is saved to the world; its beloved history, and cherished memories, are vindicated; and its happy future fully assured, and rendered inconceivably grand.”
—Abraham Lincoln (1809–1865)