Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If you can at least do up to question 3 and show the queries/results, I will be very grateful. If you do not mind doing

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

If you can at least do up to question 3 and show the queries/results, I will be very grateful. If you do not mind doing all the questions, I will be giving the largest like ever given. Thank you so much for your time.

Use the following database to answer all parts of this question (show only the Outputs). Table: EMP Primary Key: E_NO Primary Key: P_NO Table: PROJECT Primary Key: PR_NO Table: SUPPLIER Primary Key: S_NO Primary Key: P_NO + PR_NO + S_NO Foreign Key: P_NO references PART Foreign Key: PR_NO references PROJECT Foreign Key: S_NO references SUPPLIER Foreign Key: PR_NO references PROJECT 1. Compute the amount to be billed to each project as "Amount". The amount for each project is computed as the sum of the amount billed to the project by all employees working on the project. The amount billed by an employee to a project is obtained as the product the hours (HRS) that the employee devotes to the project and the billing rate (E_RATE) for the employee (show only the output of the query). 2. Compute the total revenue generated by each department as "Revenue". The Revenue for each department is computed as the sum of the amount billed to all projects controlled by the department. (Note that the PR_DEPT for a project represents the controlling department for the project) (show only the output of the query). 3. List the names of employees who only work in projects located (PR_LOC) in New York (NY) (show only the output of the query). 4. List the name of employees who work on all projects (show only the output of the query). 5. List the project numbers (PR_NO) for projects that have only received parts that are stored in (P_CITY) the same city as the project (show only the output of the query)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions