- Home
- Ask a Question
- Question Details
Consider the relation schemas given below:
STUDENT (student_id, name)
ENROLLEDIN (student_id, subject_code)
SUBJECTS (subject_code, lecturer)
Write relational algebra for the following:
i) who teaches CP 1500 or CP 3020
ii) who teaches at least two different subjects?
iii) what are the names of the students taking a subject taught by Roger?