Question 2 ABC Sdn. Bhd. involves in several projects with their clients. The company stores the project details in Table 8 below. However, some anomalies occur when data is being updated. As a person who has knowledge in database, you try to help the company by normalizing the table below. Table 8: Employee Project Employee Employee No. Name S10001 A Smith Department No. L004 Department Name IT Hourly Rate 22.00 S10030 LJones LO23 Pensions 18.50 S21010 P Lewis 1004 21.00 S10010 B Jones L004 IT 21.75 Project Project Title Project Project Code Manager Budget PC010 Pensions M Phillips 24500 System PC010 Pensions M Phillips 24500 System PC010 Pensions M Phillips 24500 System PC045 Salaries H Martin 17400 System P0045 Salaries H Martin 17400 System PC045 Salaries H Martin 17400 System PC045 Salaries H Martin System PC064 HR System K Lewis 12250 PO064 HR System K Lewis 12250 PO064 HR System K Lewis 12250 PC010 Pensions M Phillips 24500 System S10001 A Smith L004 IT 18.00 531002 T Gilbert L028 Database 25.50 17400 S13210 W Richards LOOB Salary 17.00 23.25 S31002 S21010 S10034 S10001 T Gilbert P Lewis B James A Smith LO28 L004 L009 LO04 Database IT HR IT 12450 16.50 22.00 Pensions S10030 S21010 S10010 Llones P. Lewis B Jones LO23 L004 1004 18.50 21.00 21.75 PC045 Salaries System H Martin 17400 IT PC064 S10001 S31002 S13210 S31002 S21010 S10034 A Smith T Gilbert W Richards T Gilbert Plewis TB James 1004 LO28 L008 L028 1004 L009 HR System 12250 K Lewis IT Database Salary Database IT HR 18.00 25.50 17.00 2325 17.50 16.50 Based on Table 8, answer the following questions: Identify the normal form for Emploxee Proiect relation. [2 marks] (b) Transform the above table (Table 8) into third normal form (3NF). [8 marks]