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 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)

Answer 1

Page- Answer As per the given information, below is the project management report of ABC company * Primary key of the above mentioned report is Employee no. * Attributes that were part of repeating group ate department no' and depictment name. * knowing the employee number we can know the employee name, department number, department name and soon. One must be use a foreign key to access the rest of the Bepeated information. So we need to split the given table into employee - info and department info.

Page-2 T Employee number - 101 135 Employee info. Employee | Hously number of -name rate L Hours Antoine Smith | $75 110 Liz Jones $137 40 Yvonne Lewis $ 55 Anita Stent 1 $109 Dense Smith | $75 1 190 Laura Davis | $111. 319 40 556 564 621 Department - Info Department number १२ Department name. IT Accounting Administration 17 22 * Now we need to ioin Employee info table with info table using the ID of both tables. the department primary

Page3 Primary. ID Employee - ID Department ID 101 | 135 319 556 504 621 -