Given the following table schemas as used in class (with primary keys shown with

Question

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)

Explanation / Answer

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:

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.