Question: Queries: Query 1 - ( Select query ) Display the list of projects and their assigned employees and their working hours Query 2 - (

Queries:
Query 1-(Select query) Display the list of projects and their assigned employees and their working hours
Query 2-(Total query) Display the number of employees (how many) and total hours worked for each project
Query 3-(Update query) Update employee working hours for over time (if anybody worked more than 40 hours on any project add 50% to their working hours for the extra hours, e.g. an employee who worked 50 hours, his working hours will be updated to 50+(50-40)*50%=55

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!