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:
.png)
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
The answer to each question is given b... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
960-C-S-D (2422).docx
120 KBs Word File
