1. Consider the following relation schema:
Employee (emp_name, emp_street, emp_city)
Works (emp_name, Company_name, salary)
Company (company_name, city)
Manager(emp_name, manager_name)
For each of the following queries, write SQL statements:
i. Find the name of all employees who work for First Bank Corporation
ii. Find the name and city of residence of all employees who work for First Bank Corporation.
iii. Find the name, street, city of residence of all employees who work for First Bank Corporation
and earn more than Rs 15,000 per month.
iv. Find all such employees who do not work for First Bank Corporation.
v. Find the name of all employees who lives in the same city as the company they work for.
vi. Find the company with smallest payroll.
vii. Find all employees who earn more than all employees of Small Bank Corporation.
viii. Assuming that a company may be located in several cities, find the name of the companies that
are locate in every city where Small Bank Corporation is located.
ix. Find the company with maximum number of branches.
x. Find the company that have maximum employees.
1
Expert's answer
2012-04-10T09:42:04-0400
Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.
Unfortunately, your question requires a lot of work and cannot be done
for free. Submit it with all requirements as an assignment to our
control panel and we'll assist you.
areeg
10.04.13, 19:34
ineed read answer
Leave a comment
Thank you! Your comments have been successfully added. However, they need to be checked by the moderator before being published.
Comments
Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.
ineed read answer
Leave a comment