relational database
Consider the relational
employee (person-name, street, city)
works (person-name, company-name, salary)
company (company-name, city)
manages (person-name, manager-name)
Give a query for each of the following:
a Find all employees who live in the same city as the company for which they work is
located.
b Find all employees who live in the same city and on the same street as their
managers.
c Find all employees in the database who do not work for the First Bank Corporation.
d Find all employees who earn more than the average salary of all employees of their
company.
e Find the company that has the most employees.
f Find the company that has the smallest payroll.
g Modify the database so that Jones now lives in Newtown.
h Give all employees of the First Bank Corporation a 10 percent raise.
i Give all managers in database a 10 percent raise.
j Give managers in the database a 10 percent raise, unless the salary would be greater
than $100,000. In such cases, give only 3 percent raise.
k Delete all tuples in the works relation for employees of Small Bank Corporation.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images