Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Employee Empid EmpName Department Contact No Emailid EmpHeadId 101 Isha E-101 1234567891 isha@gmail.com 105 102 Priya E-104 1234567892 priya@yahoo.com 103 103 Neha E-101 1234567893 neha@gmail.com
Employee Empid EmpName Department Contact No Emailid EmpHeadId 101 Isha E-101 1234567891 isha@gmail.com 105 102 Priya E-104 1234567892 priya@yahoo.com 103 103 Neha E-101 1234567893 neha@gmail.com 101 104 Rahul E-102 1234567894 rahul@yahoo.com 105 105 Abhishek E-101 1234567895 abhishek@gmail.com 102 IsPermanent EmpSalary EmpId Salary 101 2000 102 10000 103 5000 104 1900 105 2300 Yes Yes No Project EmpId Project StartYear EndYear 101 P-1 2010 2010 102 P-2 2010 2012 103 -1 2013 104 2-4 2014 2015 105 p-4 2015 Yes Yes Create the table EmpSalary, 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 emailld is in gmail.* Your answer Activ Go to s 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started