Q:

What is the 2nd normal form?

My informal representation of these are:
1NF: The table is divided so that no item will appear more than once.
2NF: ?
3NF: Values can only be determined by the primary key.
I cannot make sense of it from the excerpts I found online or in my book. How do I differentiate between 1NF and 2NF?

A:

A relation schema is in 2NF if every non-prime attribute is fully functionally dependent on every key.

