database normalization 2nf, 3nf
A simple mnemonic:


The key (1NF - no data items repeated in more than one place within the row)
The whole key (2NF - nothing relates to just a part of a composite key)
Nothing but the key (3NF - nothing is related to a non-key attribute)


. . . So help me Codd.