Update this database with the following stored modules and submit the updated
Update this
CompanyDB.sql file as your solution. Additionally, provide screenshots for all the code
1. A stored procedure that takes in a department identifier and prints a list of all employees
in that department.
2. A stored procedure that lists all employee names that do not have any dependents.
3. A function that takes in an employee id and returns the number of hours the employee is
working on all their assigned projects
4. A stored procedure that updates the ‘Hours’ field for all employees in the employee table
using a cursor and the function defined in part 3.
5. Triggers that are activated after any inserts, deletes, or updates on the WORKS_ON table.
The triggers will update the Hours field in the Employee table to reflect any changes for
the hours worked.
6. A stored procedure that lists any employees working less than 20 hours.
Step by step
Solved in 3 steps with 1 images
