Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations.

Question:

Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write an expression in SQL for each of the queries below:

a. {< a > | ∃ b (< a, b >∈ r ∧ b = 17)}

b. {< a, b, c > | < a, b >∈ r ∧ < a, c >∈ s}

c. {< a > | ∃ c (< a, c >∈ s ∧ ∃b1, b2 (< a b1 > ∈ r ∧ < c, b2 > ∈ r ∧ b1 > b2))}

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

Question Posted: