Given the relations shown below, show the results of the following relational operations: S S# $1...

Transcribed Image Text:

Given the relations shown below, show the results of the following relational operations: S S# $1 S2 S3 S4 S5 city Paris Berne Oslo .null. Paris P P# P1 P2 P3 P4 P5 city Paris Berne Rome .null. .null. J J# City J1 | Paris J2 Rome J3 Oslo J4 .null. J5 Rome 1. The projection of S on city (1pt.) 2. The union of result from step (1) and the projection of P on city (1pt.) 3. The set difference of result from step (1) and the projection of P on city (in that order) (1pt.) 4. The product of P and J (2pt.) 5. The natural join of P and J (2pt.) Given the relations shown below, show the results of the following relational operations: S S# $1 S2 S3 S4 S5 city Paris Berne Oslo .null. Paris P P# P1 P2 P3 P4 P5 city Paris Berne Rome .null. .null. J J# City J1 | Paris J2 Rome J3 Oslo J4 .null. J5 Rome 1. The projection of S on city (1pt.) 2. The union of result from step (1) and the projection of P on city (1pt.) 3. The set difference of result from step (1) and the projection of P on city (in that order) (1pt.) 4. The product of P and J (2pt.) 5. The natural join of P and J (2pt.)