User Account

All Pages

Find the names and city of persons who work for manager

Assignment Help Other Subject
Reference no: EM131154835

Consider the following relations with key underlined

lives (person_name, street, city)

works (person_name, company_name, salary)

located (company_name, city)

manages (person_name, manager_name)

Answer the following using SQL:

(i) Find the names and city of persons who work for manager John.

(ii) Find the names of persons who live in the same city as the company they work for.

(iii) John's manager has changed. The new manager is Anna.

(iv) Susan doesn't work anymore.

(v) Create a view BangWork (person_name, company_name, manager_name) of all people who work in Bangalore in ascending order of person name.

Reference no: EM131154835

Questions Cloud

What are the three data anomalies that are likely to occur : What are the three data anomalies that are likely to occur as a result of data redundancy? Can data redundancy be completely eliminated in database approach? Why or why not
What kind of writing happens in your intended profession : how successful were you at writing in your major classes?- What kind of writing happens in your intended profession or field?
Common language infrastructure : Explain the services provided by Common Language Infrastructure.
Disk that has both logical and physical block sizes : Consider a file system on a disk that has both logical and physical block sizes of 512 bytes. Assume that the each file is already in a memory. The file size is 512k and we are currently at a logical block 5 and want to access the information at o..
Find the names and city of persons who work for manager : Find the names and city of persons who work for manager John. Find the names of persons who live in the same city as the company they work for. John's manager has changed. The new manager is Anna
Determine the dimension b for which the shear center o : A thin-walled beam of uniform thickness has the cross section shown. Determine the dimension b for which the shear center O of the cross section is located at the point indicated.
What is structured query language : What is structured Query Language? Write the SQL command for deleting tuple(row) from the database?
Juvenile participation in gangs and how it effects economy : Write a paper:- Juvenile participation in gangs and how it effects the economy.-Show how many teens get invoved in gangs from early ages until adulthood.
Start menu to find programs : You're working with a typical user who doesn't know much of ANYTHING about computers, let alone Windows. They're notorious for losing track of documents they worked on, and they hate having to go into the Start menu to find programs. List three tw..

Reviews

Write a Review

Other Subject Questions & Answers

  How you will improve internal relations of schools personnel

Describe in detail the strategic plan to improve internal communication you would devise, and explain how you will improve internal relations of the school's personnel.

  Individual assignment human service scenario analysis

Individual Assignment Human Service Scenario Analysis

  Determine the support reactions at the fixed support at A

Determine the support reactions at the fixed support at A and the rockers at B and C for the compound beam shown below.

  Coastal town of portmouthampton

The coastal town of Portmouthampton want to build a monument to celebrate their town's success. Having learned the lessons from the Spinnaker Tower, the council will not proceed with the project unless they have a project plan that can convince th..

  What are the steps you need to take to hire these new

you have recently been hired as the administrator of a skilled nursing facility in los angeles california.you decide

  Discuss the relationship between jessica and shylock

Discuss the relationship between Jessica and Shylock. Are we meant to sympathize with the moneylender's daughter? Does Shakespeare seem ambivalent in his portrayal of Jessica

  Evolution of programs and services paper grading criteria

Evolution of Programs and Services Paper Grading Criteria

  Study for the department of labor statistics,

As part of a study for the Department of Labor Statistics, you are assigned the task of evaluating the improvement in productivity of small businesses. Data for one of the small businesses you are to evaluate is shown below. The data are the monthly ..

  Quality is standard problem

Standard Corporation can not claim a trademark in the phrase “Quality Is Standard” if the phrase

  What is an example of a level in a designed experiment

What is an example of a LEVEL in a designed experiment?

  Describes the reason companies seek out foreign markets

Which of the following best describes the reason companies seek out foreign markets in order to take advantage of business cycle differences among countries?

  The author of the correlation and causation reading

Which of the following is NOT a specific problem that makes the interpretation of correlational relationships difficult? High school students in Mississippi, where teacher salaries are low, were found to score better on the SAT than did high school s..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd