Express each of the following queries using relational algebra

1. Find the course id and section id for all courses offered in the Spring of 2020.

2. Find the names of all students who have finished or are taking Database Design.

Do not use any natural joins in your answer.

3. Assume that Michael Scott is a student at the university, and there has only ever

been one Michael Scott there. Find the names of all students with more credits

completed than Michael Scott.

4. Find the names and IDs of all students who have taken a course taught by Dr. Who.

Use at least one natural join in your answer. Be careful with this question!

5. Find the department and course id of all classes that were taught or are being

taught by an instructor from a different department. Use at least one set operations

( , , or ) in your query.

6. Find the name and ID of all students who are taking all of the courses that Dr. Who

is teaching in the Spring 2020 semester.

7. Find the IDs of all students who have taken all of the CMPSC courses. Use the

division operation.

8. Do the same operation as in problem 7, using only fundamental operations

student takes ID course id sec id semester 1er 4112 dept_name tot cred grade advisor section course_id sec id semester year building TOOM_10 time_slof_id course course id title dept name credits department dept name building budget time slot time slot id day start time end time instructor classroom prerea course id prereg id ID name building NOOM O Capacity feaches dept_name salary ID course id serid semester Express each of the following queries using relational algebra. (10 points each) Note: Your queries should use as few relations as arguments as possible (i.e. do not include relations that are not needed to produce the results). student takes ID course id sec id semester 1er 4112 dept_name tot cred grade advisor section course_id sec id semester year building TOOM_10 time_slof_id course course id title dept name credits department dept name building budget time slot time slot id day start time end time instructor classroom prerea course id prereg id ID name building NOOM O Capacity feaches dept_name salary ID course id serid semester Express each of the following queries using relational algebra. (10 points each) Note: Your queries should use as few relations as arguments as possible (i.e. do not include relations that are not needed to produce the results)