EmpNo DeptNo DeptName E001 D1 Human Resource Francis Kimani Employee Name Male EmployeeGender E002 D2 Sales...

 

Transcribed Image Text:

EmpNo DeptNo DeptName E001 D1 Human Resource Francis Kimani Employee Name Male EmployeeGender E002 D2 Sales Francisca Kamau Female E003 D3 Marketing Benard Rotich Male E004 D1 Human Resource Bemice Rotich Female E005 D2 Sales Faith Wambua Female ii. Convert this table into third normal form. iii. Store the records into the resultant table(s). 6 Marks Activ 4 Marks o EmpNo DeptNo DeptName E001 D1 Human Resource Francis Kimani Employee Name Male EmployeeGender E002 D2 Sales Francisca Kamau Female E003 D3 Marketing Benard Rotich Male E004 D1 Human Resource Bemice Rotich Female E005 D2 Sales Faith Wambua Female ii. Convert this table into third normal form. iii. Store the records into the resultant table(s). 6 Marks Activ 4 Marks o