Consider the following relational database schemes: COURSES(Cno, Name)…

PYQ GATE 1998

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.

Attempted by 1 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…