(Solved): PART II- Specify the following views and a trigger in SQL on the COMPANY database schema shown. EMP ...

PART II- Specify the following views and a trigger in SQL on the COMPANY database schema shown. EMPLOYEE Fname Minit Lname Sen Bdate DEPARTMENT Dname Dnumber Mr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Phame Pnumber DEPENDENT Essn Plocation Dnum WORKS ON Essn Pho Hours Dependent name Sex Salary Address Sex Bdate Super_san Relationship Dno a) (10 points) A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project. b) (10 points) A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project with more than one employee working on it. c) (10 points) Write a trigger that whenever an employee's project assignments are changed, check if the total hours per week spent on the employee's projects are less than 30 or greater than 40; if so, notify the employee's direct supervisor.