Solve 3.4 and 3.5

Questions are from Database Systems.

FET 3.4 Here is a query on the suppliers-and-parts database. What does it do? What is the predicate for the result? ( ( s JOIN SP ) WHERE P# = P# ('P2') ) { S#, CITY } 3.5 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