Second normal form
Second normal form (2NF) is a normal form used in database normalization.wikipedia
14 Related Articles
Second normal form (2NF) is a normal form used in database normalization.
Codd went on to define the second normal form (2NF) and third normal form (3NF) in 1971, and Codd and Raymond F. Boyce defined the Boyce-Codd normal form (BCNF) in 1974.
That is addressed in third normal form.
Requiring existence of "the key" ensures that the table is in 1NF; requiring that non-key attributes be dependent on "the whole key" ensures 2NF; further requiring that non-key attributes be dependent on "nothing but the key" ensures 3NF.
It is worth noting that this design meets the additional requirements for second and third normal form.
functional dependenciesfunctionally dependentinspired from relational database theory
A functional dependency on part of any candidate key is a violation of 2NF.
Alternate keydefining database keykey
In addition to the primary key, the relation may contain other candidate keys; it is necessary to establish that no non-prime attributes have part-key dependencies on any of these candidate keys.
attributeattribute valuesattribute-value centric
List of computing topics
4NF4NF database normalization
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.
Without the use of views, the normalization of databases above second normal form would become much more difficult.
BCNFBoyce-Codd normal formBoyce Codd Normal Form
Recall that 2NF prohibits partial functional dependencies of non-prime attributes (i.e., an attribute that does not occur in any candidate key.