retagged by
252 views
0 votes
0 votes
Consider the following relations:
STD CHOICES (Student ID, Course ID, Semester) and
COURSE ASSIGN (Teacher ID, Course ID, Semester).
The former indicates the choice of courses for students and the latter indicates the courses 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 OR SQL query OR relational Algebra 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.
retagged by

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
Aakanchha asked May 3, 2018
629 views
Let R(A, B, C) be a relation with primary key (A) and S(A, D, E) a relation with primary key (A, D). Each of the relations has n tuples. If the number of tuples in R natu...
2 votes
2 votes
2 answers
3
vidhyuth asked Mar 22, 2017
336 views
Prove that the language {aN : N is a composite number} is notregular.
0 votes
0 votes
1 answer
4
MiNiPanda asked May 9, 2018
565 views
Let R(A,B,C) be a relation with primary key (A) and S(A,D,E) a relation with primary key (A,D). Each of the relations has n tuples. If the number of tuples in R natural j...