Question: b . Given the table below which contains information about the employees and projects they are working on , and it's used to calculate the
b Given the table below which contains information about the employees and projects they are working on and it's used to calculate the weekly payments. Here is the table with sample data to help you understand it
tabletableProjectcodetableProjectNametableProjectManagertableEmployeeNotableEmployeeNametableDepartmentNotableDepartmentNametableHourlyRatetableProjectbudgetPAli,Ahmed,ITD,PAli,Salem,ITD,PAli,Zeenat,SDDPYara,Ahmed,ITD,PYara,Fatima,SDDPOthman,Zeenat,SDD
Convert the following table to an equivalent collection of tables that are in third normal form.
ProjectsWeeklyPay Project code, Employee No Project Name, Project Manager, Employee Name, Department No Department Name, Hourly Rate, Project budget
The following dependencies exist in the Patient table:
Project code, Employee NoProject Name, Project Manager, Employee Name, Department No Department Name, Hourly Rate, Project budget
Project code Project Name, Project Manager, Project budget
Employee No Employee Name, Department No Department Name, Hourly Rate
Department No Department Name
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
