Relational algebra and SQL Express each of the following queries as both relational algebra expressions and SQL Throughout the rest of these questions, you should express the answer using as few relations as possible.

Find the IDs of all instructors who have students as advisees.

Relational Algebra:

SQL:

Find the room numbers of all rooms in the Olmsted building.

Relational Algebra:

SQL:

Find the course ids of courses that have been taught in all of the classroom buildings.

Relational Algebra:

Find the course ids of the courses with the highest number of credits.

Relational Algebra:

SQL:

student takes ID course_id sec_id semester year name dept_name tot_cred grade section advisor course id sec_id course course_id title dept_name credits semester department dept_name building budget Slid i id year building room_no time_slot_id time_slot time slot_id day start_time end_time instructor classroom building room_no capacity prereq course_id prereg_id ID name dept_name salary teaches course_id sec_id semester year