second normal form


Also found in: Acronyms, Wikipedia.

second normal form

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
Mentioned in ?
References in periodicals archive ?
Figure 3b shows three relations that constitute second normal form. In each relation, taken individually, each nonkey field is dependent on its entire key, not just part of it.
Although that relation satisfies the rules for second normal form, it will still produce redundant data because one of its nonkey fields (GARAGE) defines another one of its nonkey fields (MANAGER), as indicated by association (10) in Figure 2.