Project+Report+Solution

2NF
Employee name, Department No and Department Name are dependent upon Employee No only (and not Employee No / Project No). Therefore, they were moved to a new table with Employee No being the key.

The Hourly Rate is dependent on both Employee No and Project No.

3NF
Department Name is dependent on Department No, and not Employee No