Question: normalization 11. (4) (Protected View) Microsoft Word non commercial use (Unlicensed Product) Mailings Review View location and might be unte. Click for more details Enable


normalization 11. (4) (Protected View) Microsoft Word non commercial use (Unlicensed Product) Mailings Review View location and might be unte. Click for more details Enable Editing Instruction: Answer all questions in question paper (85 Marks) Figure 1 shows an extrad 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 RM 24,500 Project Budget Employee No. Employee Name Hourly Rare Department No. Department Name S10001 IT 1004 RM22.00 Ali Smith S10030 Walid Jones L02 Pensions RM 18 50 S21010 Fahn Lewis 1004 IT RM 21.00 S00232 1003 Rahim Smith Khadar Ali S11341 RM 26.00 RM21.50 Programming Programming Pensions L004 S10608 LOS4 RM23,00 IT RM5.00 S30062 musse L011 w 7 BOX OM 96 $ 4. & 7 ( 9 ) 0 3 5 6 8 E R Y U normalization 11. (4) (Protected View) - Microsoft Word non-commercial use (Unlicensed Product) Mailings Review View and might be unsate. Click for more details Enable Editing S11341 Khadar L004 Programming RM21.50 S10608 Ali L054 Pensions RM23.00 S30062 musse L011 IT RM25.00 Total Staff on Project: 4 Average Hourly Rate: RM 21.88 Figure 1: Project Management Report for Project Code: PC101 1. Draw UN-Normalized Table based on figure A)1 above [2 marks] 2 Based on Un-normalized Table from step A)1 you need to perform complete normalization process until Third Normalization Form (3NF) Draw complete normalization table for each normalization process 19 marks] w 200 ax
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
