Problem
Intro to database part of SQL
Use relational algebra
I. Find all courses that are from the Comp Sci department with 3 or more credits.
II. List students' names along with the departments that offered courses the student has taken. Note: be careful about the JOIN conditions.
III. Find all the students' names and IDs who have taken CS-101 in Fall 2009 and failed (assumption: failing grade is F).
IV. Find all the students' names and IDs who got an A, A- or B in BIO-101.
V. Find all the students' names and IDs who got an A in Robotics, Investment Banking and Game Design.