Back 

Step 2 - From 1NF to 2NF

STEP 2 - Take the database in 1NF and put it into 2NF
A database is in 2NF if it is in 1NF and all the non-key attributes depend ENTIRELY upon the primary key! An alternative way of viewing this is to ask yourself which of the non-key attributes need both key attributes specified to get back a value for the non-key attribute. If a non-key attribute needs both key attributes, then that non-key attribute stays with the table with the compound primary key. If the non-key attribute does not need both key attributes, then it is moved into another table. Now this is a mouthful again, but the good news is that, like riding a bike, it is a lot easier to see and do than explain!

2a) If any table in 1NF has a simple primary key (made up of only one attribute) then it is automatically in 2NF and can be copied across to the 2NF column.

t4

2b) The next step is to identify those non-key attributes (i.e. attributes that are NOT part of a compound primary key) which are related to only PART of the compound key.