CONVERT TO RELATIONAL ALGEBRA EXPRESSION (Data base management system) 1. SELECT cNo FROM course WHERE cNo IN (SELECT cNo FROM enrolled); 2.

CONVERT TO RELATIONAL ALGEBRA EXPRESSION (Data base management system)

1.SELECT cNo

FROM course

WHERE cNo IN (SELECT cNo FROM enrolled);

2.SELECT cno

FROM course

WHERE cno NOT IN (SELECT cno FROM enrolled);

3.Select student.name,course. cname

FROM student, course,enrolled

WHERE student.student_id = enrolled.student_id;

4.Select student.student_id, course.cname

FROM student,enrolled, course

WHERE (student.student_id = enrolled.student_id ) and (course.cName = 'gg' OR course.cName = 'df');