64 693
Assignments Done
99,3%
Successfully Done
In September 2018

Answer to Question #8290 in Databases | SQL | Oracle | MS Access for Arindam si

Question #8290
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.
Expert's answer
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.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

Assignment Expert
26.04.13, 16:01


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

Ask Your question

Submit
Privacy policy Terms and Conditions