Consider the Schema diagram for a university database

a. Find the course id and section id for all courses offered in the Spring of 2020. b. Find the names of all students who have finished or are taking Database Design. Do not use any natural joins in your answer. c. 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.

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)