Register

DBMS Korth Edition 6 Exercise 6 Question 6 (Page No. 251)

• edited by
1,064 views
1 votes
1 votes
Let R = (A, B, C), and let r1 and r2 both be relations on schema R. Give an expression in the domain relational calculus that is equivalent to each of the following:

a. $\prod _A(r1)$
b. $\sigma _{B =17} (r1)$
c. r1 ∪ r2
d. r1 ∩ r2
e. r1 − r2
f. $\prod _{A,B}(r1) \Join \prod _{B,C}(r2)$
• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
3
ajaysoni1924 asked Mar 30, 2019
573 views
DBMS Korth Edition 6 Exercise 6 Question 17 (Page No. 254)
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. ... ))}
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 | $\exist...
User Avatar
0 votes
0 votes
1 answer
4
ajaysoni1924 asked Mar 27, 2019
704 views
DBMS Korth Edition 6 Exercise 6 Question 18 (Page No. 254)
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations. Using the special constant null, write tuple-relational-calculus expressions equivalent to each of the following: a. r $ROJ$ s b. r $FOJ$ s c. r $LOJ$ s
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations.Using the special constant null, write tuple-relational-calculus expressionsequivalent to each of the f...
User Avatar
Link Copied!