Page 1 of 1

Artist (ssn, name, age, rating) Theater (tno, tname, address) Perform (ssn, tno, date, duration, price) Question 4 (5

Posted: Fri May 20, 2022 12:31 pm
by answerhappygod
Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 4 5 1
Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 4 5 1 (3.99 KiB) Viewed 32 times
Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 4 5 2
Artist Ssn Name Age Rating Theater Tno Tname Address Perform Ssn Tno Date Duration Price Question 4 5 2 (8.61 KiB) Viewed 32 times
Artist (ssn, name, age, rating) Theater (tno, tname, address) Perform (ssn, tno, date, duration, price)

Question 4 (5 points): Consider the schema in Question 2. Please convert the SQL statement you obtained for 2.2 (Retrieve the name of each artist who performs in the “Sacramento Memorial Auditorium” today) to the relational algebra.