Question

We will use the database schema from the SQL assignment: student sidcourse cid prerequisite cid pre.cid record sid cid qtr year grade Consider the following queries (from the SQL assignment): 2. Find the courses taken by every student who has taken CSE132A Note that, if no student has taken CSE132A, then all courses should be in the answe For queries (1) and (2) do the following: (iii) write the SQL query corresponding directly to the relational calculus query in (ii), that uses only NOT EXISTS tests on nested queries

Find the courses taken by every student who has taken CSE132A. Note that, if no student has taken CSE132A, then all courses should be in the answer. Write the SQL query that uses only NOT EXISTS tests on nested quieries

Answer 1

If you have any doubts, please give me comment...

SELECT cid

FROM course C

WHERE NOT EXISTS(

SELECT *

FROM student S

WHERE NOT EXISTS(

SELECT *

FROM record R

WHERE R.sid = S.sid AND R.cid = C.cid AND C.cid = 'CSE132A'

)

);