edited by
764 views
0 votes
0 votes
Consider the following relations:

$\text{STD_CHOICES } (\underline{\text{Student_ID}}, \underline{\text{Course_ID}}, \text{Semester})$ and

$\text{COURSE_ASSIGN} (\underline{\text{Teacher_ID}}, \underline{\text{Course_ID}}, \underline{\text{Semester}})$.

The former indicates the choice of courses for students and the latter indicates the course assigned to teachers for different semesters. Note that each student may take multiple courses, each teacher can teach multiple courses and each course can also be taught by multiple teachers. Write the relational calculus expression to output the ID for all the students who have not been taught by the same teacher in more than one course across all semesters.
edited by

Please log in or register to answer this question.

Related questions

1 votes
1 votes
2 answers
1