Question: 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,
![2. Draw Unnormalized Table after step A)1 above. [2 marks] [See](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f5c26a9b950_12266f5c26a4c53a.jpg)

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. Figure 1 shows an extract from a company report, which describes projects being worked upon by employees Project Management Report PC010 Project Code: Project Title: Pensions System Project Manager: Daud Alam Project Budget: RM 24,500 Employee No. Department No. Department Hourly Rate Name Employee Name Ali Smith Wahid Jones Fahmi Lewis L004 IT S10001 S10030 RM 22.00 L023 Pensions RM 18.50 S21010 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
