Question: Below is a sample Project Management Report that ABC Company uses. Your task is to begin the process of creating a set of normalized relations

Below is a sample Project Management Report that ABC Company uses. Your task is to begin the process of creating a set of normalized relations based on this form. Project Management Report Project No. Project Title: 035 Pensions System Project Manager: Project Budget: Mike Phillips $75,000 Department No. Department Name Number of Hours 110 40 Employee No. 101 135 316 556 564 621 Total Statt: 200 Employee Name Antoine Smith Liz lones Yvonne Lewis Anita Stent Denise Smith Laura Davis 6 Hourly Rate $75 $137 $55 $109 $75 $111 $94 Accounting Administration 40 190 60 Accounting Average Rate: Note. Hourly rate is the rote charged for each employee to any project that the employee is assigned Show the NNF relational schema for the above form. (4 points) b. Why is the above schema not yet INF-be very specific. (2 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
