Register

ISI 2017 PCB C3 (B)

• retagged by
406 views
0 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.

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · ISI PCB 2017Next → · MadeEasy Test Series...
← Previous in category · ISI PCB 2017Next in category → · Self - Doubt : How t...
Position:
Show:

Related questions

0 0 votes
1 1 answer
1.5k
1.5k views
Aakanchha asked May 3, 2018
1,515 views
ISI 2017 PCB C3 (A)
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...
0 0 votes
1 1 answer
858
858 views
Ajeet Singh asked Apr 30, 2018
858 views
ISI PCB 2017
Consider the following relations:STD CHOICES (Student ID, Course ID, Semester) andCOURSE ASSIGN (Teacher ID, Course ID, Semester).The former indicates the choice of cours...
2 2 votes
2 2 answers
710
710 views
vidhyuth asked Mar 22, 2017
710 views
ISI PCB 2014 C3 (A)
Prove that the language {aN : N is a composite number} is notregular.
0 0 votes
1 1 answer
1.1k
1.1k views
MiNiPanda asked May 9, 2018
1,097 views
ISI-2017 C3 (a)
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...