Querying Multiple Relations

• What does the following query compute?

SELECT S.name, E.cid

FROM Students S, Enrolled E

WHERE S.sid=E.sid AND E.grade=“A”

Given the following instance of Enrolled (is this possible if the DBMS ensures referential integrity?):

we get:

Previous slide

Next slide

Back to first slide

View graphic version