Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

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

Step: 3

blur-text-image

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

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

More Books

Students also viewed these Databases questions

Question

What is employee requisition?

Answered: 1 week ago

Question

4. Make recommendations on steps to take to melt the glass ceiling.

Answered: 1 week ago

Question

1. Discuss the potential legal issues that relate to training.

Answered: 1 week ago