Fourth normal form
Normal form used in database normalization concerned with multivalued dependency
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).
Nº Q2492261 ★
Common · History
Fourth normal form
Normal form used in database normalization concerned with multivalued dependency
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).
From Wikipedia
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 ↠ {\displaystyle \twoheadrightarrow } Y, X is a superkey—that is, X is either a candidate key or a superset thereof.
Text: Wikipédia, CC BY-SA 4.0. ·
Related cards
-
S
Second normal form
Database normalization requirement after first normal form
Nº Q277396 ★★
Not listed
-
T
Third normal form
Normalizing a database design to reduce the duplication of data and ensure referential integrity
Nº Q311585 ★★
Not listed
-
S
Sixth normal form
Relational database normalization form which generalizes relational operators to support interval data
Nº Q4523348 ★
Not listed
-
F
First normal form
Minimum requirement in database normalization
Nº Q1366465 ★★
Not listed
-
4th Dimension (software)
Relational database and programming language
Nº Q238349 ★★
Not listed
-
F
FFF system
System of units based on the furlong (length), the firkin (mass), and the fortnight (time)
Nº Q5425426 ★
Not listed