Database system concept 7thbased on Exercise problems 3.9, 3.10, 3.16, and 3.17) Consider the relational database of Figure 3.19, where the primary keys are underlined. Given an expression in SQL for each of the following queries.Find the ID of each employee who does not work for “First Bank Corporation”. SQL Query:Find the ID, name, and city of residence of each employee who works for “First Bank Corporation” and earns more than $10,000. SQL Query:Find the ID of each employee who earns more than every employee of “Small Bank Corporation”. SQL Query:Assume that companies may be located in several cities. Find the name of each company that is located in every city in which “Small Bank Corporation” is located. Your query should run on. SQL Query:Find the name of the company that has the most employees (or companies, if there is a tie). SQL Query:Find the name of each company whose employees earn a higher salary on average, than the average salary at “First Bank Corporation”. SQL Query:Modify the database so that the employee whose ID is ‘12345’ now lives in a city called “Newtown”. SQL Query:Find ID and name of employee who lives in the same city as the location of the company for which the employee works. SQL Query:Find ID and name of each employee who earns more than the average salary of all employees of her or his company. SQL Query:Find the company that has the smallest payroll (sum of all salary in a company). SQL Query:Given all employees of “First Bank Corporation” a 10 percent raise. SQL Query:Delete all tuples in the works relation for employees of “Small Bank Corporation”. SQL Query: employee (ID, person name, street, city)works (ID, compапу name, salarу)сотрany (сompаny name, city)manages (ID, manager.id)Figure 3.19 Employee database.

1. Find the ID of each employee who does not work for “First Bank Corporation”. SQL Query: select ID…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Database system concept 7th

Find the ID of each employee who does not work for “First Bank Corporation”. SQL Query:
Find the ID, name, and city of residence of each employee who works for “First Bank Corporation” and earns more than $10,000. SQL Query:
Find the ID of each employee who earns more than every employee of “Small Bank Corporation”. SQL Query:
Assume that companies may be located in several cities. Find the name of each company that is located in every city in which “Small Bank Corporation” is located. Your query should run on. SQL Query:
Find the name of the company that has the most employees (or companies, if there is a tie). SQL Query:
Find the name of each company whose employees earn a higher salary on average, than the average salary at “First Bank Corporation”. SQL Query:
Modify the database so that the employee whose ID is ‘12345’ now lives in a city called “Newtown”. SQL Query:
Find ID and name of employee who lives in the same city as the location of the company for which the employee works. SQL Query:
Find ID and name of each employee who earns more than the average salary of all employees of her or his company. SQL Query:
Find the company that has the smallest payroll (sum of all salary in a company). SQL Query:
Given all employees of “First Bank Corporation” a 10 percent raise. SQL Query:
Delete all tuples in the works relation for employees of “Small Bank Corporation”. SQL Query: