Hello guys,

I need a help with this database related problem. I am new to Database and relational algebra can any one pleaas help with this problem. A pic of the problem is attached below.

Thanks,

7. (5 pts each) Use the following schema to give the relational algebra equations for the following queries Student (sid:integer, sname:string, major:string) Class (cid:integer, cname: string, cdesc: string) Enrolled (sid:integer, cid: integer, esemester: string, grade: string) Building (bid: integer, bname: string) Classrooms (crid:integer, bid: integer, crfloor: int) ClassAssigned (cid: integer, crid: integer, casemester: string) a. Find all the student's names enrolled in CS430dl. b. Find all the classes Hans Solo took in the SP16 semester. c. Find all the classrooms on the second floor of building "A" d. Find all the class names that are located in Classroom 130. e. Find all the buildings that have ever had CS430dl in one of their classrooms. f. Find all the classrooms that Alice Wonderland has been in, g. Find all the students with a CS major that have been in a class in either the "A" building or the "B" building. Find all the classrooms that are in use during the S h. S16 semester