Inorder to convert a table into 3NF we must :
- Find and remove non-key attributes that are functionally dependent on attributes that are not the primary key. Place them in a different table.
- Group the remaining attributes.
As for example, to convert the table Employee ( refer to the Third Normal Form (3NF) link :
http://churmura.com/third-normal-form-3nf/) into 3NF, you must remove the column DEPTHEAD since it is not functionally dependent on only the primary key ECODE and place it in another table called DEPARTMENT along with the attribute DEPT that it is functionally dependent on.
