Second Normal Form (SNF)

A database design term.

There are various ways to design a relational database and the 'Normal Form' describe how efficiently the data is stored. Another word for this is 'Normalisation'

There is 'First Normal Form' which is the least efficient as it allows some data to be duplicated, but it is easy to design.

Then 'Second Normal Form' that gets rid of most duplication but will allow some redundancy for convenience sake.

Then the strictest form is 'Third Normal Form' that tries to get rid of any duplicate data although this tends to need more tables than the other forms.

Challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Second Normal Form


back to glossaryback to glossary