The last section of this chapter presented four main rules that characterize updatable views in SQL. The third rule states that if the WHERE clause contains a nested subquery, none of the tables mentioned in that subquery (explicitly or implicitly) can be the table used in the FROM clause of the viewde?nition.
Construct a viewthat violates condition 3 but satis?es conditions 1, 2, and 4 for updatability, such that there is an update to this viewthat has two di?erent translations into the updates on the underlying base relation.
Consider two relation schemas, R(Att1,Att2)andS(Att1,Att2), and a view:
```
CREATE VIEW V(Att1)
SELECT A.Att1
FROM V A
WHERE EXISTS (
SELECT *
FROM S B
WHERE B.Att1 = A.Att1 AND B.Att2 = A.Att2 )
```
Here the base table of the view, R, is implicitly mentioned in the subquery (through the tuple variable A). Now, suppose we want to delete a tuple of the form a, b from V. There are two translations: to delete all tuples of the form a, ? from R or from S.
You might also like to view...
Use set operator and subquery to find employees, who do not have any dependents.
Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)
The default behavior of the print spooler is to receive print jobs and release them to be printed in the order in which they are received
Indicate whether the statement is true or false
Which switch is used with the Windows netstat utility to show the process ID?
A. -p B. -o C. -n D. -b
Contingency planning falls into the _________ class of security controls.
Fill in the blank(s) with the appropriate word(s).