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:
“‘Tis said of love that it sometimes goes, sometimes flies; runs with one, walks gravely with another; turns a third into ice, and sets a fourth in a flame: it wounds one, another it kills: like lightning it begins and ends in the same moment: it makes that fort yield at night which it besieged but in the morning; for there is no force able to resist it.”
—Miguel De Cervantes (1547–1616)
“Unlike the normal pattern, I know I have grown more liberal as I’ve grown older. I have become more convinced that there is room for improvement in the world.”
—Walter Wellesley (Red)
“Quintilian [educational writer in Rome around A.D. 100] thought that the earliest years of the child’s life were crucial. Education should start earlier than age seven, within the family. It should not be so hard as to give the child an aversion to learning. Rather, these early lessons would take the form of play—that embryonic notion of kindergarten.”
—C. John Sommerville (20th century)