Question

5.10 Express each of the following queries in relational algebra and (ii) SQL using the Student Registration System schema of Figure 3.4. a. List all courses that are taught by professors who belong to the EE or MGT departments.

Answer 1

Answer 1:

select * from Course where deptId in ('EE','MGT')

Answer 2:

Select Name from Sudent where StudId in ( select StudId from Transcript group by StudId having CrsCode='Spring 1997' and CrsCode='fall 1998' );

NOTE - I am little bit confused between crsCode and crsName. i mean given data"Spring 1997" and "fall 1998" belongs to crsCode or crsName. So i am writing the another query that consumes data as crsName if that is the case.

Select Name from Sudent where StudId in ( select StudId from Transcript group by StudId having CrsCode in (select crsCode from course where crsName in('Spring 1997' , 'fall 1998' )));