Question: 2:45 S 30% - RSS E-101 E-104 101 Isha 102 Priya 103 Neha 104 Rahul 105 Abhishek E-101 1234567891 Isha@gmail.com 105 1234567892 priya@yahoo.com 103 1234567893

 2:45 S 30% - RSS E-101 E-104 101 Isha 102 Priya
103 Neha 104 Rahul 105 Abhishek E-101 1234567891 Isha@gmail.com 105 1234567892 priya@yahoo.com
103 1234567893 neha@gmail.com 101 1234567894 rahul@yahoo.com 105 1234567895 abhishek@gmail.com 102 T E-102
E-101 EmpSalary EmpId Salary IsPermanent 101 2000 Yes 102 10000 Yes 103
5000 No 104 1900 Yes 105 2300 Yes Project EmpId Project StartYear
EndYear 101 p-1 2010 2010 102 P-2 2010 2012 103 p-1 2013
104 p-4 2014 2015 05 p-4 2015 111 2:45 wat 30% Create
the table EmpSalary, set the referential integrity cascade when user update or
delete an employee.* T Your answer Select the detail of the employee
whose name start with P. Your answer III K 2:45 wat 30%

2:45 S 30% - RSS E-101 E-104 101 Isha 102 Priya 103 Neha 104 Rahul 105 Abhishek E-101 1234567891 Isha@gmail.com 105 1234567892 priya@yahoo.com 103 1234567893 neha@gmail.com 101 1234567894 rahul@yahoo.com 105 1234567895 abhishek@gmail.com 102 T E-102 E-101 EmpSalary EmpId Salary IsPermanent 101 2000 Yes 102 10000 Yes 103 5000 No 104 1900 Yes 105 2300 Yes Project EmpId Project StartYear EndYear 101 p-1 2010 2010 102 P-2 2010 2012 103 p-1 2013 104 p-4 2014 2015 05 p-4 2015 111 2:45 wat 30% Create the table EmpSalary, set the referential integrity cascade when user update or delete an employee.* T Your answer Select the detail of the employee whose name start with P. Your answer III K 2:45 wat 30% How many permanent candidate take salary more than 5000.* T Your answer Select the detail of employee whose emailld is in gmail.* Your answer 111 2:45 wat 30%- What is total salary that is paid to permanent employees? * T Your answer How many project started in year 2010.* Your answer III K diabadi 3 2:45 wil 30% How many project started and finished in the same year. T Your answer Select the name of the employee who is supervised by Abhishek'.* Your answer III K 2:45 Il 30%- Display the id of employees with salaries >= 800 and

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!