Question: Consider the relational database of Figure. Using SQL, define a view consisting of manager-name and the average salary of all employees who work for that

Consider the relational database of Figure. Using SQL, define a view consisting of manager-name and the average salary of all employees who work for that manager. Explain why the database system should not allow updates to be expressed in terms of this view.

employee (employee-name, street, city) works (employee-name, company-name, salary) mpany (compa-, ity) manages

employee (employee-name, street, city) works (employee-name, company-name, salary) mpany (compa-, ity) manages (employee-name, manager-name)

Step by Step Solution

★★★★★

3.46 Rating (169 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Create view salinfo as select managername avgsalary from ... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

16-CS-DB (141).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Consider the relational database of Figure. Give an expression in the relational algebra for each request: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First...

Consider the relational database of Figure. Write a Datalog program for each of the following queries: a. Find all employees who work (directly or indirectly) under the manager Jones. b. Find all...

Consider the relational database of Figure. Give an expression in SQL for each of the following queries. a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First Bank...

only d e f thanks 3.9 Consider the relational database of Figure 3.19, where the primary keys are underlined. Give an expression in sql for each of the following queries. a. Find the id, name, and...

Please do not answer if you cannot answer all of them. Problem 6. Answer 6.1-6.2 using Employee database employee (employee name, street, city) works (employee name, company_name, salary) company...

Part 1: Atlas Corporate Human Resource Data Requirements This document describes the needs of the Atlas Corporate Human Resources department in managing the data surrounded its employees and their...

1 What update anomalies occur in the EMP _ PROJ and EMP _ DEPT relations of figure given below? 2 What are the different types of SQL injection attacks? What preventive measures are possible against...

Answer in SQL please employee (employee name, street, city) works (employee name, company_name, salary) company (company_name, city) manages (employee name, manager_name) 3.16 Consider the employee...

Consider the employee database of Figure 3.20, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names of all employees who work for...

For a store with 3 locations, daily sales (in thousands) were taken from each location for a series of dates: Is there any significant difference in median daily sales between the 3 locations? Test...

Brenda Vowlski has a 2-year, $2,500 car loan at 9%. After paying on the loan for 3 months, Brenda has a balance of $2,211.46. She decides to pay off the loan with the next payment. How much will she...

Question 2 A guard should run before navigating to a child route. The guard only allows an Admin user to navigate to the EditComponent and ViewComponent. Here is the sample code, ALL { path:...

Refer to Fig. 4.67. The Thevenin resistance at 4.4 terminals a and b is: (a) 25 0 (b) 20 n (d) 40 (e) 5 5 ww a 20 50 V b

Healthy women aged 18 to 40 participated in a study of eating habits. Subjects were given bags of potato chips and bottled water and invited to snack freely. Interviews showed that some women were...

The Notch mutation is a deletion on the X chromosome of Drosophila melanogaster. Female flies heterozygous for Notch have an indentation on the margins of their wings; Notch is lethal in the...

Deer mice are small rodents native of North America. Their adult body lengths are known to vary approximately Normally, with mean = 86 mm and standard deviation = 8 mm. A research uses a random...

Deer mice (Peromyscusmaniculatus) are small rodents native to North America. Their body lengths excluding tails is known to vary approximately Normally with mean = 86 mm and standard deviation = 8...

If disposal of industrial liquid wastes by incineration is to be a feasible process, it is important that the toxic chemicals be completely decomposed into harmless substances. One study carried out...

Consider the issue of interesting orders in optimization. Suppose you are given a query that computes the natural join of a set of relations S. Given a subset S1 of S, what are the interesting orders...

Consider the query: select * from r, s where upper(r.A) = upper(s.A) where upper is a function that returns its input argument with all lowercase letters replaced by the corresponding uppercase...

Show that, with n relations, there are (2(n1))!(n1)! different join orders. A complete binary tree is one where every internal node has exactly two children. Use the fact that the number of different...

Write pseudocode for an iterator that implements indexed nested-loop join, where the outer relation is pipelined. Your pseudocode must define the standard iterator functions open(), next(), and...

Suppose you need to sort relation r using sort-merge and mergejoin the result with an already sorted relation s. a. Describe how the sort operator is broken into sub operators to model the pipelining...

Ten years ago, News Corp. raised capital by issuing 20-year quarterly coupon bonds with $1,000 par value. a. If investors required 12% return, quarterly compounding, for News Corp.s bonds when the...