Second normal form (2NF), in database normalization, is a normal form that is met if each attribute that is not part of the primary key depends on all parts of the primary key. More formally, a relation is in the second normal form if it fulfills the following two requirements:
It is in first normal form.
It does not have any non-prime attribute that is functionally dependent on any proper subset of any candidate key of the relation (i.e. it lacks partial dependencies). A non-prime attribute of a relation is an attribute that is not a part of any candidate key of the relation.
Put simply, a relation (or table) is in 2NF if:
It is in 1NF and has a single attribute unique identifier (UID)(in which case every non key attribute is dependent on the entire UID), or
It is in 1NF and has a multi-attribute unique identifier, and every regular attribute (not part of the UID) is dependent on all attributes in the multi-attribute UID, not just one attribute (or part) of the UID.
If any regular (non-prime) attributes are predictable (dependent) on another (non-prime) attribute, that is addressed in third normal form.
and 23 Related for: Second normal form information
Third normalform (3NF) is a database schema design approach for relational databases which uses normalizing principles to reduce the duplication of data...
normalforms (from least normalized to most normalized) are: UNF: Unnormalized form 1NF: First normalform 2NF: Secondnormalform 3NF: Third normal form...
linear algebra, a Jordan normalform, also known as a Jordan canonical form (JCF), is an upper triangular matrix of a particular form called a Jordan matrix...
First normalform (1NF) is a property of a relation in a relational database. A relation is in first normalform if and only if no attribute domain has...
level of normalization after Boyce–Codd normalform (BCNF). Whereas the second, third, and Boyce–Codd normalforms are concerned with functional dependencies...
In mathematical logic, a formula is in negation normalform (NNF) if the negation operator ( ¬ {\displaystyle \lnot } , not) is only applied to variables...
algebra, the Frobenius normalform or rational canonical form of a square matrix A with entries in a field F is a canonical form for matrices obtained...
In differential geometry, the second fundamental form (or shape tensor) is a quadratic form on the tangent plane of a smooth surface in the three-dimensional...
into an equivalent grammar in Greibach normalform. Various constructions exist. Some do not permit the secondform of rule and cannot transform context-free...
In mathematics and computer science, a canonical, normal, or standard form of a mathematical object is a standard way of presenting that object as a mathematical...
a normal distribution or Gaussian distribution is a type of continuous probability distribution for a real-valued random variable. The general form of...
database normalization, unnormalized form (UNF or 0NF), also known as an unnormalized relation or non-first normalform (N1NF or NF2), is a database data...
The secondnormal-form game is the normalform representation of the subgame starting from Player 1's second node with actions A and B. For the second normal-form...
Shegalkin) polynomials (Russian: полиномы Жегалкина), also known as algebraic normalform, are a representation of functions in Boolean algebra. Introduced by...
has been variously called as modified Jordan form, reordered Jordan form, second Jordan form, and H-form. The current terminology is credited to Shapiro...
the result of the operation or by using transfinite recursion. Cantor normalform provides a standardized way of writing ordinals. In addition to these...
Thoralf Skolem had considered the Skolemizations of formulas in prenex form as part of his proof of the Löwenheim–Skolem theorem (Skolem 1920). Herbrand...
statistics (where the exponent of a zero-mean multivariate normal distribution has the quadratic form − x T Σ − 1 x {\displaystyle -\mathbf {x} ^{\mathsf {T}}{\boldsymbol...
In mathematics, particularly in combinatorial group theory, a normalform for a free group over a set of generators or for a free product of groups is...
Next to Normal is a 2008 American rock musical with book and lyrics by Brian Yorkey and music by Tom Kitt. The story centers on a mother who struggles...