Database system Normalization

Figure 1 shows an extract from a company report, which describes projects being worked upon by employees. Project Management Report Project Code: PC010 Project Title: Pensions System Project Manager: Daud Alam Project Budget: RM 24,500 Employee No. Employee Name Hourly Rate Department No. Department Name S10001 Ali Smith L004 IT RM 22.00 S10030 Wahid Jones L023 Pensions RM 18.50 S21010 Fahmi Lewis L004 IT RM 21.00 S00232 Rahim Smith L003 Programming RM 26.00 Total Staff on Project: 4 Average Hourly Rate: RM 21.88 Figure 1: Project Management Report for Project Code: PC101 Task: A) Phase 1 - Database Design 1. Insert three (3) new data for Employee No., Employee Name, Department No., Department Name and Hourly Rate in Project Management Report for Project Code: PC010 as shown in Figure 1. Draw your new report for Project Code: PC010. [1.5 marks] 2. Draw Unnormalized Table after step A)1 above. [2 marks] [See Next Page MTD3033 : Database System 3 3. Based on Unnormalized Table from step A)2, you need to perform complete normalization process until Third Normalization Form (3NF). Draw complete normalization table for each normalization process. [9 marks)