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.

$1.99
Sales0
Views196
Comments0
  • CreatedNovember 03, 2009
  • Files Included
Post your question
5000