Database1

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