Question: Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write relational-algebra expressions equivalent to the following domain-relationalcalculus

Let R = (A, B) and S = (A, C), and let r(R) and s(S) be relations. Write relational-algebra expressions equivalent to the following domain-relationalcalculus expressions:

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

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

c. {< a > | ∃ b (< a, b >∈ r) ∨ ∀c (∃ d (< d, c >∈ s) ⇒ < a, c >∈ s)}

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

Step by Step Solution

3.39 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a IIA B 17 r b r 1 s c IIA r r B IICs d IIrA r 1 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

16-CS-DB (130).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!