Question: Consider the following database schema and specify the following queries or views in SQL EMPLOYEE (SSN, name, salary, DNo) DEPARTMENT (DNo, DeptName, MgrSSN) PROJECT (PNo,

 Consider the following database schema and specify the following queries or

Consider the following database schema and specify the following queries or views in SQL EMPLOYEE (SSN, name, salary, DNo) DEPARTMENT (DNo, DeptName, MgrSSN) PROJECT (PNo, location, ProjName) HOURLOG (SSN, PNo, hours) (a) Find the sum of salaries of all employee, the maximum salary, the minimum salary, and the average salary. (b) Find the total number of employees in the 'Research' department. (c) Find the SSN and name of the employee who works on more than two projects. (d) For each project, retrieve the PNo, ProjName, and the number of employees from department number 2 (i.e., DNo 2) who work on the project. (e) Create a view 'DEPT_INFO' that has the department name, the number of employees, and the total salary of the total salary of the employees of the department

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!