Write name of employee on every project located in houston

Assignment Help Database Management System

Reference no: EM1356137

Q1) EMPLOYEE(SSN, NAME, SEX, DNUMBER)
DEPARTMENT(DNUMBER, DNAME, DMGRSSN)
DLOCATION(DNUMBER, DLOCATION)
PROJECT(PNUMBER, PNAME, PLOCATION)
WORKSON(SSN, PNUMBER, HOURS)

Write the following queries in SQL:

1. List the name(s) of employee(s) who works(work) on every project located in 'Houston.'

2. List the name(s) of employee(s) who only works(work) on every project located in 'Houston.'

3. List the name(s) of employee(s) who works(work) on every project except the one(s) located in Houston.

4. List name(s) of employee(s) who works(work) on exactly all projects located in 'Houston.

Reference no: EM1356137

Questions Cloud

Question on journal entries-treasury stock : Gore Inc. has outstanding 10,000 shares of $10 par value common stock. On July 1, 2008, Gore reacquired 100 shares at $85 per share. On September 1, Gore reissued 60 shares at $90 per share.

Create a representation of actual sections : Global Employee handbook - Create a representation of actual sections of an employee handbook

Find interest rate of the return on investment : Suppose you purchase a ten year bond with 6 percent annual coupons. You hold the bond for four years, and sell it immediately after receiving the fourth coupon.

Steps of accounting cycle : Can you please describe to me in detail the steps of the accounting cycle? please include references searched the solution library and need new information.

Write name of employee on every project located in houston : Write the name(s) of employee(s) who works(work) on every project located in Houston. Write the name(s) of employee(s) who only works(work) on every project located in 'Houston.'

Important information about multiverse remix : A few days ago you helped me with the challenges of Multiverse Remix. Are you interested in helping with the "Global Issues" as well? Again, these are small pieces of a huge project.

Explain what are some of the traits that makes this leader : Explain What are some of the traits that makes this leader head and shoulders above others?

Illustrate what price should the firm charge if it wants : Illustrate what price should the firm charge if it wants to maximize its profits in the short run. What arguments can be made for charging a price higher than this price.

Global quality standards of a hospital : Explain why are global quality standards important to external shareholders? Please provide an example of how global standards benefit a hospital organization's shareholders.

User Account

All Pages