{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Consider the nested query we saw in section 1344

Info iconThis preview shows pages 9–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Consider the nested query we saw in Section 13.4.4 which finds the names of all instructors who taught a course in 2007. Write the query in relational algebra using the multiset semjoin operation, ensuring that the number of duplicates of each name is the same as in the SQL query. (The semijoin operation is widely used for decorrelation of nested queries.) Answer: The query can be written as follows: instructor instructor . I D = teaches . I D ( H9268 year = 2007 ( teaches ))
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}