Specify the following views in MySQL on the COMPANY database schema shown in Figure 3.5:

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

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

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.

A view that has the project name, controlling deaprtment name, number of employees, and total hours worked per week on the project for each project with more than one employee working on it.

Figure 3.5 - Schema diagram for the COMPANY relational database schema

EMPLOYEE

Fname

Minit

Lname

Ssn

Bdate

Address

Sex

Salary

Super_ssn

Dno

DEPARTMENT

Dname

Dnumber

Mgr_ssn

Mgr_start_date

DEPT_LOCATIONS

Dnumber

Dlocation

PROJECT

Pname

Pnumber

Plocation

Dnum

WORKS_ON

Essn

Pno

Hours

DEPENDENT

Essn

Dependent_name

Sex

Bdate

Relationship