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.
\table[[\table[[Project],[code]],\table[[Project],[Name]],\table[[Project],[Manager]],\table[[Employee],[No]],\table[[Employee],[Name]],\table[[Department],[No]],\table[[Department],[Name]],\table[[Hourly],[Rate]],\table[[Project],[budget]]],[1,P1,Ali,1,Ahmed,1,ITD,20,1200],[1,P1,Ali,2,Salem,1,ITD,19,1200],[1,P1,Ali,3,Zeenat,2,SDD,21,1200],[2,P2,Yara,1,Ahmed,1,ITD,20,1800],[2,P2,Yara,4,Fatima,2,SDD,21,1800],[3,P3,Othman,3,Zeenat,2,SDD,21,23000]]
Convert the following table to an equivalent collection of tables that are in third normal form.
Projects_Weekly_Pay (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 No)(Project 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)
b . Given the table below which contains

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 Programming Questions!