Write a relational algebra statement that produces a relation with the columns:

course$\_$id

title

prereq$\_$course$\_$id

prereq$\_$course$\_$title

This relation represents courses and their prereqs.

Note:

This query requires the course and prereq tables.

Your answer should only include courses in the Comp. Sci. department.

If a course has no prereqs, prereq$\_$course$\_$id and prereq$\_$course$\_$title should both be null.

You may have to use table and column renaming.

Algebra statement: