Suppose the expression in Exercise 3.4 is used in a view definition: CREATE VIEW V AS (S

Question:

Suppose the expression in Exercise 3.4 is used in a view definition: CREATE VIEW V AS (S JOIN SP) WHERE P# - P# (‘P2’) ) {S#, CITY}; Now consider this query: (V WHERE CITY = ‘London’ ) {S#} What does this query do? What is the predicate for the result? Show what is involved on the part of the DBMS in processing this query.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

College Physics

ISBN: 978-0321601834

7th edition

Authors: Jerry D. Wilson, Anthony J. Buffa, Bo Lou

Question Posted: