second normal form

Definition

A stage in the normalization of a relational database in which it is in first normal form and every non-key attribute is dependent upon the entire primary key.