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

  Neuro developmental and neurocognitive disorders paper

Neurodevelopmental and Neurocognitive Disorders Paper

  History evolves through a dialectical process

The major ways in which nature was represented in romantic painting, Who introduced the neoclassical style in architecture to the United States? According to Hegel, history evolves through a dialectical process.

  Barriers influencing effective communication

What barriers influence effective communication within the criminal justice system?

  What is the relationship between instincts and motives

What is the relationship between instincts and motives?

  The estimated population mean based problems

If we select a random sample of 50 households, what is the standard error of the mean?

  Question regarding the world religions

Huston Smith's book on The World Religions provides an in-depth analysis of the major religions in the world. In his book, Smith does not create a comparative exploration of the major religions. Rather, the author describes each religion separatel..

  Social cognitive theory-internal factors in self-regulation

In examining Albert Bandura: Social Cognitive Theory, "Internal Factors in Self-Regulation". There are three main factors presented (1) Self-observation, (2) Judgmental Processes, (3) Self-Reaction in answering this what does God's Word teach us abou..

  What do you think is the topic of conversation

Differentiate between the gestures used by males vs. females-conclude if there is a noticeable difference. Compare what the research says in relation to what you observed.

  Many communities and states provide recommendations that

address the following in 4 pages1.are there existing public communication programs processes systems efforts and plans

  Michael wants to know more about the mental process student

explain  is better addressed using a quantitative, rather than a qualitative, methodology.

  Learned and innate behavior among humans.

Discuss and explore the differences between learned and innate behavior among humans.

  Levels of core stability and dynamic flexibility

Are there sports that require high levels of core stability and low levels of dynamic flexibility? What about low core stability and high dynamic balance? Are these two variables naturally intertwined or can they be achieved independently?

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