Specify the following views in SQL on the COMPANY database schema shown in Figure 5.5.

a. A view that has the department name, manager name, and manager salary for every department.

b. A view that has the employee name, supervisor name, and employee salary for each employee who works in the 'Research' department.

c. 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.

d. 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.

*****This is exercise 7.8 from textbook "Fundamentals of Database Systems 7th Edition" by Elmasri and Navathe*****

EMPLOYEE Fname Minit Lname Sen Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr ssn Mgr_start_ date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber PlocationDnum WORKS ON Essn Pno Hours Figure 5.5 Schema diagram for the COMPANY relational database schema. DEPENDENT Essn Dependent name SexBdate Relationship