Given the following table schemas as used in class with prim

Given the following table schemas as used in class (with primary keys shown with ___ over them):

Student (S)
___
SID LastName FirstName Credits GPA
---------------------------------------------------------

Course (C)
___
CID DeptName DeptNumber CourseName
-----------------------------------------------------------

Takes (T)
________________
SID CID Semester Grade
------------------------------------

3. Show the first and last names of students who have taken every CS and every BIOL course (using Relational Algebra and Domain Relational Calculus)

Solution

select LastName ,FirstName from Students S,Takes T,Course C where S.SID = T.TID and T.CID = C.CID and CourseName=\'CS\' or CourseNAme=\'BIOL\'

Reational Algebra: