Create the table Employee-Salary, set the referential integrity cascade when user update or delete an employee. *

Your answer

Select the detail of the employee whose name start with P. *

Your answer

How many permanent candidate take salary more than 5000. *

Your answer

Select the detail of employee whose email Id is in g-mail. *

Your answer

What is total salary that is paid to permanent employees? *

Your answer

How many project started in year 2010. *

Your answer

How many project started and finished in the same year. *

Your answer

Select the name of the employee who is supervised by Abhishek. *

Your answer

Display the id of employees with salaries >= 800 and

Your answer

Write an SQL query to fetch the list of employees with the same salary.

Your answer

Write an SQL query to fetch the names of workers who earn the highest salary. *

Your answer

Display the employee information not working in department E-101 *

Your answer

Display all employees in descending order by the employee name *

Your answer

Finds the average salaries of all employees *

IV - SQL Queries : Consider the following Relational schema and Relations instances. (30 points) Employee (Ernipid, EmpName, Department, Contacto Emailld, Ertup Headld) EmpSalary (Empld, Salary .IsPermanent ) Project (Empld.Project Start Year End Year) Write SQL queries that will do the following Employee Empid 181 102 103 104 105 EmpName Isha Priya Neha Rahul Abhishek Department E-101 E-104 E-101 Contact NO 1234567891 1234567892 1234567893 1234567894 1234567895 Emailid isha@gmail.com priya@yahoo.com neha@gmail.com rahul@yahoo.com abhishek@gmail.com EmpHeaded 10S 103 101 105 102 E-102 E-101 EmpSalary Project EndYear 2010 2012 Epid 101 102 103 104 105 Salary 2000 10000 S000 1900 2300 Is Permanent Yes Yes No Yes Yes Empid 101 102 103 104 105 Project p-1 P-2 p-1 P-4 p-4 StartYear 2010 2010 2013 2014 2015 2015