Question: need albrega and SQL expression code for these, thank you Suppose we have following tables: employee (ename, city, state) - company (cname, city, state) -

need albrega and SQL expression code for these, thank you

Suppose we have following tables: employee (ename, city, state) - company (cname, city, state) - job (ename, cname, salary) Please write algebra expressions for following queries: 1. Find the names and cities of all employees who work for the PNC Bank. 2. Find the names, cities and states of all employees who work for PNC Bank and earn more than $100,000 per year. Assume each person works for at most one company. 3. Find the names of all employees who live in the same city as their companies. Next, please convert above algebra to SQL statement. Please save your 5QL code to Q2.sql for submission. Please note: This question can be done without real tables and data. But if you would like to test your SQL code, you can make up your own tables and data according to above table schema; Or you can also choose to use my demo database file using DB Browser

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

solve all the 5 questions. Thank you (c) Consider the following relational database: EMPLOYEE (e-name, street, city) COMPANY (c-name, city) For each of the following queries, give an expression...

Answer 1b and c(all the questions). Thank you (b) Express the division operation as a sequence of few basic relational algebra operations, and verify with arn example if the sequence of basic...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Hi please read and answers the following questions: 1. What was the most interesting thing in the chapter to you? Why? 2. What in the chapter were you able to directly relate to your own...

23 Nickel and Dimed: On (Not) Getting By in America BARBARA EHRENREICH Major changes in welfare legislation in 1996 eliminated cash payments to millions of America's poor, requiring them to find...

The relational schema for student course registration are as followsParents - S ( F - NID, M - NID, Sid, F - name, M - name, street, city, income ) Student ( Sid , name, street, city. Mobile, email,...

You have been provided with the description of a programming language, J, intended for scripting applications. Its syntax is similar to a cut-down version of Java in that it consists of function...

Using the data tables attached, please provide the SQL query for each question. What is the customer information for customers who live in Los Angeles? What is the average value of all approved...

B and C please In a Word document, write SQL statements for the questions below, and include a screen snapshot for the result produced by each SQL statement. Ensure your document has a section titled...

b and c please In a Word document, write SQL statements for the questions below, and include a screen snapshot for the result produced by each SQL statement. Ensure your document has a section titled...

The activity format calls for three categories on the statement of cash flows. Define each category.

On January 1, 2020, Sandhill Corporation had the following stockholders equity accounts. Common Stock ($20 par value, 63,500 shares issued and outstanding) $1,270,000 Paid-in Capital in Excess of...

An asset is expected to generate a cash flow at the end of each year continuing on forever. The first cash flow of $ 1 5 0 0 is expected at the end of next year. Investors currently expect this cash...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. As the HR Manager, you must provide the senior management team with turnover costs for the following high-turnover position. Use websites such as www.talentkeepers.com and www.keepemployees.com,...

LO4 Discuss how flexible work arrangements are linked to worklife balancing efforts.

LO5 Describe job analysis and the stages in the process.