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 freeLoading lesson…

