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:
“Newsmen believe that news is a tacitly acknowledged fourth branch of the federal system. This is why most news about government sounds as if it were federally mandated—serious, bulky and blandly worthwhile, like a high-fiber diet set in type.”
—P.J. (Patrick Jake)
“Normality highly values its normal man. It educates children to lose themselves and to become absurd, and thus to be normal. Normal men have killed perhaps 100,000,000 of their fellow normal men in the last fifty years.”
—R.D. (Ronald David)
“Freedom of religion, freedom of the press, and freedom of person under the protection of habeas corpus, and trial by juries impartially selected. These principles form the bright constellation which has gone before us, and guided our steps through an age of revolution and reformation.”
—Thomas Jefferson (1743–1826)