Find the persons whose salaries are more than that of all of the ‘Oracle’ employees. (v) Find the names of the companies that are located in every city where the company ‘Infosys’ is located.

Consider the following relations: WORKS(Pname, Cname, Salary) LIVES(Pname, Street, City) LOCATED_IN(Cname, City) Manager(Pname, Mgrname) Where Pname = Person name, Cname = Company name and Mgrname = Manager name. Write the SQL queries for the following: AUGUST 2013 Code: CS33 Subject: DATABASE MANAGEMENT SYSTEMS CS33 / AUGUST – 2013 2 ALCCS – OLD SCHEME ROLL NO. ___________________ (i) List the names of the people who work for the company Wipro along with the cities they live in. (ii) Find the names of the persons who live and work in the same city. (iii)Find the names of the persons who do not work for ‘Infosys’. (iv)Find the persons whose salaries are more than that of all of the ‘Oracle’ employees. (v) Find the names of the companies that are located in every city where the company ‘Infosys’ is located.


 

. TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post Find the persons whose salaries are more than that of all of the ‘Oracle’ employees. (v) Find the names of the companies that are located in every city where the company ‘Infosys’ is located. appeared first on Term Paper Tutors.

The post Find the persons whose salaries are more than that of all of the ‘Oracle’ employees. (v) Find the names of the companies that are located in every city where the company ‘Infosys’ is located. first appeared on Term Paper Tutors.

 

"Is this question part of your assignment? We Can Help!"

Essay Writing Service