Database

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. Department Name IT Hourly Rate 22.00 Pensions 18.50 IT 21.00 IT 21.75 IT 18.00 Database 25.50 Table 8: EmployeeProject Project Project Title Project Project Employee Employee Department Code Manager Budget No. Name No. PC010 Pensions M Phillips 24500 S10001 A Smith L004 System PC010 Pensions M Phillips 24500 S10030 LJones LO23 System PC010 Pensions M Phillips 24500 S21010 P Lewis L004 System PC045 Salaries H Martin 17400 S10010 B Jones L004 System PC045 Salaries H Martin 17400 S10001 A Smith L004 System PC045 Salaries H Martin 17400 S31002 T Gilbert LO28 System PC045 Salaries H Martin 17400 S13210 W Richards L008 System PC064 HR System K Lewis 12250 S31002 T Gilbert L028 PC064 HR System K Lewis 12250 S21010 P Lewis L004 PC064 HR System K Lewis 12250 S10034 B James L009 PC010 Pensions M Phillips 24500 S10001 A Smith L004 System S10030 L Jones LO23 S21010 P Lewis L004 PC045 Salaries H Martin 17400 S10010 B Jones L004 System S10001 A Smith L004 S31002 T Gilbert LO28 S13210 W Richards L008 PC064 HR System K Lewis 12250 S31002 T Gilbert LO28 S21010 P Lewis L004 S10034 B James L009 Salary 17.00 Database IT HR IT 23.25 17.50 16.50 22.00 Pensions IT IT 18.50 21.00 21.75 IT Database Salary Database IT HR 18.00 25.50 17.00 23.25 17.50 16.50 Based on Table 8, answer the following questions: Based on Table 8, answer the following questions: (a) Identify the normal form for Employee Project relation. [2 marks] (b) Transform the above table (Table 8) into third normal form (3NF). [ [8 marks]