Question 11941 – Image-Processing
November 21, 2023Digital-Logic-Design
November 21, 2023SQL
Question 7
|
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.
Theory Explanation.
|
Correct Answer: A
Subscribe
Login
0 Comments