Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Marketing The Ultimate Marketing Tool

Authors: Edward L. Nash

1st Edition

0070460639, 978-0070460638

More Books

Students also viewed these Databases questions