Consider three tables T1, T2 and T3 below. Show the results of the following operations:

(for each question, you need to write down the attribute names on the top, similar to tables below)

T1 (P R C) T2 (A B C) T3 (A B C)

10 x 5 10 x 6 10 x 6

15 y 5 25 y 3 30 z 3

25 z 6 10 x 5 25 z 6

10 y 5 25 z 6

30 z 6

a) s _R=y (T1)

b) s _{A=25 and C=5} (T2)

c) p_R (T1)

d) p_A,B (T2)

e) T1 X T3 (The Cartesian product)

f) T1 equi-join _{(T1.C = T3.C)} T3 [equi-join is done on the specified attributes] (i.e., get all combination of tuples that have equal values on join condition attributes, T1.C and T3.C; attribute list is the same as the Cartesian Product)

g) T1 natural-joinT3 [natural join is done on the common attribute(s)] (i.e., get all combination of tuples that have equal values on the common attribute(s),(attribute list is less than the Cartesian Product; the common attribute(s) are listed only once)

h) T1 equi-join _{(T1.P = T3.A)} T3 [equi-join is done on the specified attributes] (i.e., get all combination of tuples that have equal values on join condition attributes, T1.P and T3.A; attribute list is the same as the Cartesian Product)

i) T2 natural-join T3 [natural join is done on the common attributes] (i.e., get all combination of tuples that have equal values on all common attributes,

(attribute list is less than the Cartesian Product; the common attribute(s) are listed only once)

10. T2 T3

(T2 intersection T3)

k) T2 - T3

l) T3 - T2