CSC 455

Fall 2009

Lab 10

Consider the following schema:

Give the relations that would result from the following operations:

X is Cartesian product, |X| is join

a) σ _C<6(T2)

b) π _Q (T1)

c) π _Q (T1) - π _B (T2)

d) σ _{P = 10} (T1 U T2)

e) T1 X T2

f) π _P(T1 |X|_T1.Q=T2.B T2)

g) π _C (σ _{P = 10} (T1 |X|_T1.P=T2.A T2)