Upon completion of this lab you should be able to:

Recognize the various relational algebra operators.

Create queries using relational algebra terminology.

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$)$

Find all the student's names enrolled in CS$430$dl$.$

Find all the classes Hans Solo took in the SP$16$ semester.

Find all the classrooms on the second floor of building $"$A$".$

Find all the class names that are located in Classroom $130.$

Find all the buildings that have ever had CS$430$dl in one of their classrooms.

Find all the classrooms that Alice Wonderland has been in$.$

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 SS$21$ semester.