Question: We have four relations r(A, B, C), s(D, E, F, G), t(H, I), and u(A, D, H, J),Consider the following query select s.name from r,
We have four relations r(A, B, C), s(D, E, F, G), t(H, I), and u(A, D, H, J),Consider the following query
select s.name from r, s, t, u where r.A = u.A and
s.D = u.D and t.H = u.H and r.B > 100 and s.E < u.J and s.F < 1000 and t.I between 500 and 5000
(a) Write the query as a relational algebra query in the form
attributescondition(r s t u)
(b) Write 5 other equivalent RA queries. Try to write queries that allow more efficient processing. (c) Draw the query trees (query plans without algorithm specification) for the queries you gave in part (b).
Please no spam answer. Also for pat b use the same querry do not use your own.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
