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 (UnlicensedProduct) Mailings Review View location and might be unte. Click for more

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!