Question: Briefly answer the following questions based on this schema: 1. Suppose you have a view SeniorEmp defined as follows: CREATE VIEW SeniorEmp (sname, sage, salary)

Briefly answer the following questions based on this schema:

Briefly answer the following questions based on this schema:
1. Suppose

1. Suppose you have a view SeniorEmp defined as follows:
CREATE VIEW SeniorEmp (sname, sage, salary)
AS SELECT E.ename, E.age, E.salary
FROM Emp E
WHERE E.age > 50
Explain what the system will do to process the following query:
SELECT S.sname
FROM SeniorEmp S
WHERE S.salary > 100,000
2. Give an example of a view on Emp that could be automatically updated by updating Emp.
3. Give an example of a view on Emp that would be impossible to update (automatically) and explain why your example presents the update problem that it does.

Emp(eid: integer, ename: string, age: integer, salary: real) Works(eid: integer, did: integer, pet.time: integer) Dept(did: integer, budget: real, managerid: integer)

Step by Step Solution

3.50 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The answer to each question is given b... View full answer

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

Document Format (1 attachment)

Word file Icon

960-C-S-D (2422).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!