DataBase Please answer these 2 questions:

SELECT statements :

Q2. Draw from the project data model to prepare a statement showing employee first name, employee

last name, employee title, and department name. Include only the records for employees who have

been assigned to a project (i.e.,employees who do not appear in the proj2emp table). To include only

such employees, your SELECT statement should use the NOT EXISTS command and an inner query. Hint

#1: This statement is very, very similar to the NOT EXISTS statement in the SQL Code Part 3 file. Hint #2:

Recall that when a statement contains a second WHERE clause (as this statement does), the second

clause must begin with the AND command.

------------------------------------------

Q3. Draw from the project data model to prepare a statement showing employee first name, employee

last name, employee title, and a calculated column based on the

product of the empHourlyWage and proj2empEstHours columns. Each field in the SELECT clause should have an alias: Employee Name;

Employee Title; and Labor Cost for Employee. Include only the records for the project ERP System.

(ERP System is a value in the projectName field; it has its own record in the project table.) Sort by the calculated column in descending order.

--------------------------------------------------------------------

PROJECT DATA MODEL project employee projectio projzempID emplD projectName projectio deptio projectDesc empID empFirstName empLastName projectEndDate empTitle empHourhyWage empEmailAddress proj empTaskDesc department deptio deptDesc PROJECT DATA MODEL project employee projectio projzempID emplD projectName projectio deptio projectDesc empID empFirstName empLastName projectEndDate empTitle empHourhyWage empEmailAddress proj empTaskDesc department deptio deptDesc