Aptitude | GATE CS 1998 | Question 85

Consider the following relational database schemes:

COURSES(Cno, name)
PRE-REQ(Cno, pre_Cno)
COMPLETED(student_no, Cno)

COURSES give the number and the name of all the available courses.
PRE-REQ gives the information about which course 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.

Answer:

Explanation:

Quiz of this Question