Question

Express the following SQL queries in relational algebra:

1) What are the dates of the concert of Lionel Richie at the Bell Center?

SELECT date FROM Concert C, Show S, Hall H

WHERE

C.show_id = S.show_id

AND S.hall_id = H.hall_id

AND S.singer = 'Lionel Richie' AND H.name = ‘Bell Center’

Answer 1

Solution:

Explanation:

Solutim. Slepti his filseng cut the tuples Lionel Richiel of Shao relation where s singes = S.singer S Tionel Richie' Stell Filtering out the tupfes of Hall relation where Hiname='Bell center' H Hinaus- Bell centes Step3: How talling gan ef sand it on the basis of undition shallid = Hikillid s H Singer : Singer' lionel Richiel Hiname='Bell cunks sinale id = H. hallid 4. How Prepy: taling join with Concest relef in tuele tent (istov?d =l-Perit and selech selecting data attribute from overall join. С Ş ㅈ date C-ftsewid = isotopes ="Tinel Ricciel sihall_id = Hohell- id thane Belt center So show_id

I have explained each and every part with the help of image attached to it.