Exercise 3.19 Briefly answer the following questions based on this schema: Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct_time: integer) Dept(did: integer, budget: real, managerid: integer) 1. Suppose you have a view SeniorEmp defined as follows: CREATE VIEW SeniorEmp (sname, sage, salary) AS SELECT E.ename, E.age, E.salary Emp E WHERE E.age > 50 FROM Explain what the system will do to process the following query: SELECT S.sname SeniorEmp S WHERE S.salary > 100,000 FROM 2. Give an example of a view on Emp that could be automatically updated by up- dating Emp. 3. Give an example of a view on Emp that would be impossible to update (auto- matically) and explain why your example presents the update problem that it does.

Exercise 3.19 Briefly answer the following questions based on this schema: Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pct_time: integer) Dept(did: integer, budget: real, managerid: integer) 1. Suppose you have a view SeniorEmp defined as follows: CREATE VIEW SeniorEmp (sname, sage, salary) AS SELECT E.ename, E.age, E.salary Emp E WHERE E.age > 50 FROM Explain what the system will do to process the following query: SELECT S.sname SeniorEmp S WHERE S.salary > 100,000 FROM 2. Give an example of a view on Emp that could be automatically updated by up- dating Emp. 3. Give an example of a view on Emp that would be impossible to update (auto- matically) and explain why your example presents the update problem that it does.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

What is the difference, precisely, between the connotative and the denotative meanings of the word?
Please describe two occasions in which you disagreed with the viewpoints of a reader or writer.Please respond to my inquiry in the space provided. the area of expertise of computer scientists.
Can a Mechanical Turk be used to successfully deceive modern humans? If you were to compare a modern Turk to a Turk from the 18th century, what would you notice?
Give a brief summary of the features, if any, that may be found in Machine Language. The inability of computers and other technical devices to understand English raises another mystery.
Is so-called good grammar necessary in the English-speaking world today? If so, why? If not, why not? Of the three articles above, which did you like best? Which was the most interesting? Why? Do you think that the rules of grammar and punctuation are changing in the world today? How? Why? Are there particular rules that you think we really need? Are there ones you think should go? Write 250-400 words in total, and then comment on at least one other post.
Do you know when the next interruption will occur? What does this have to do with switching contexts?
What details on the philosopher Tollman can you provide?
Is it still feasible to trick people nowadays with a machine like Mechanical Turk? If you were to recreate the Turk of the eighteenth century, what would be the distinctions between it and the Turk of today?
Is it still feasible to trick people nowadays with a machine like Mechanical Turk? If you were to recreate the Turk of the eighteenth century, what would be the distinctions between it and the Turk of today?