Q27

Consider the following relational database schemes: COURSES (Cno, Name) PRE_REQ(Cno, Pre_Cno) COMPLETED (Student_no, Cno) COURSES gives the number and name of all the available courses. PRE_REQ gives the information about which courses are pre-requisites for a given course. COMPLETED indicates what courses have been completed by students Express the following using relational algebra: List all the courses for which a student with Student_no 2310 has completed all the pre-requisites.