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.

Figure 5.5:

Transcribed Image Text:

ΕMPLOYEΕ Minit Lname Ssn Sex Salary Super_ssn Dno Fname Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours Figure 5.5 Schema diagram for the DEPENDENT COMPANY relational Essn Dependent_name Sex Bdate Relationship database schema.