Question: Question 3 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow: Emp (eid: integer, ename: string, age: integer,

Question 3 SQL queries (10 marks) Consider the following relational schema and briefly answer the questions that follow: Emp (eid: integer, ename: string, age: integer, salary: real) Works (eid: integer, did: integer, pct_time: integer) Dept (did: integer, budget: real, managerid: integer)

b. Write SQL statements to delete all information about managers whose salaries are more than twice of the average salary of the employees in the department. Be sure to ensure that all the relevant integrity constraints are satisfied after your updates.

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!

Consider the following relational schema and briefly answer the questions that follow: Emp ( eidinteger , ename: string, age: integer, salary: real ) Works eid: integerdid: integer, pct time: integer...

I am not sure how to write the commands for these . Consider the following relational schema and briefly answer the question that follows: Emp(eid: integer, ename: string, age: integer, salary: real)...

Consider the following relational schema and briefly answer the questions that follow: 1. Define a table constraint on Emp that will ensure that every employee makes at least $10,000. 2. Define a...

Consider the following relational schema and briefly answer the questions that follow: Emp ( eid: integer, ename: string, agentegersalaryreal ) Works ( eldinteger , did: integer, pct theinteger )...

Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a given employee works...

Answer this question using subqueries if needed. Table must prompt in my SQL workbench, thanks! 3. Retrieve the name of employees, whose salary is higher than the average of all employees, and their...

Answer this question using subqueries if needed. Thanks! 1. Find the minimum, maximum, and average salary in each department. Query: DROP DATABASE IF EXISTS HW1; CREATE DATABASE HW1; Use HW1; CREATE...

Problem 1. (35pts] Consider the following relational schema. An employee can work in more than one department; the pct_time field of the Works relation shows the percentage of time that a given...

Task 2 (50 points): Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a...

Maria is a 67-year-old retired, obese woman, who lives with her husband Max. She enjoys sitting down to a movie every night with a bottle of Shiraz and a large packet of salt and vinegar chips or tub...

What are [Sr2+] and [SO42] in a saturated solution of SrSO4(s)? The Ksp of SrSO4(s) is 3.8 104.

We are evaluating a proiect that costs 5 7 8 8 , 4 9 0 , has a nineyear life, and has no salvage value. Rypume that depreciation is atraightline to aero over the ile of the project. Sales are...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

How does the Job Level Table differ from the Job Family and Occupation Tables, and how are all Three tables related?

What is the Definition for Third Normal Form?

Provide two examples of a One-To-Many relationship.