577 views
0 votes
0 votes
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations.
Write SQL Queries equivalent to the following domain relational-
calculus expressions:
a. {< a > | $\exists  b (< a, b > \epsilon¸r \wedge b$ = 17)}
b. {< a, b, c > | < a, b > $\epsilon¸ r \wedge < a, c > \epsilon¸ $s}
c. {< a > $ | \exists b (< a, b > \epsilon  ,r ) \vee \forall c (\exists d (< d, c > \epsilon s) \Rightarrow< a, c > \epsilon ,$ s)}
d. {< a > | $\exists c (< a, c > \epsilon, s \wedge \exists b1, b2 (< a, b1 > \epsilon, r \wedge  < c, b2 >
\epsilon r \wedge b1 > b2$))}

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
0 votes
0 votes
0 answers
2