2. Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all the normalized tables (from 3NF).

2. Normalize the following form into UNF INF, 2NF and 3NF. Show primary keys and foreign keys for all the normalized tables (from 3NF). [7 marks] Employee Task Record Form Employee ID ni 587 Employee Name: Smith Department ID: D1 Department Name: IT Taskid TI T2 T3 TaskName Designing Drawing Reporting Duration 70hrs 56hrs 60hrs SupervisorID SupervisorName Emp_TaskJoin Date S1 Khalfan 12/12/2019 S2 Fatma 01/10/2020 S3 Haitham 11/11/2020 Employe e ID Employe Departme Duration Department Name Taskt e Name nt ID Task Name Supervisor. D Supervisor Name 587 Smith DI IT 70hrs T1 Designing S1 Khalfan Emp.Ta . skJoin Date 12/12/20 19 01/10/20 20 11/11/20 20 587 Smith D1 IT 56hrs T2 Drawing S2 Fatma 587 Smith D1 IT 60hrs T3 Reporting S3 Haitham Identify the correct table name & Keys in 3NF (2 Marks) Table Name Primary key Foreign Key(If any)