Convert the following table into an equivalent collection of tables that are in third normal form.
Employee( EmpNum, EmpLastName, EmpFirstName, EmpBirthDate, EmpDegree1, EmpDegree2, JobID, JobClassification, JobTitle, EmpDependent1, EmpDependent2, DeptCode, DeptName)
2.Develop the following:
1.1NF Relation, primary key, and functional dependencies
2.2NF Relations, primary key, and functional dependencies
3.3NF Relations, primary key, and functional dependencies
3.Underline the primary key and clearly label your answer for #1, #2, and #3, i.e., use the numbers above