Register

Korth

393 views
0 votes
0 votes
give domain relation calculus expression

works(person-name, company-name, salary)

find the names of all employees who earn more than every employee of Small Bank Corporation
User Avatar

1 Answer

0 votes
0 votes
r1 <-----person-name (works) -

r2 <---- (Πworks.person-name (works) Narural Join
(works.salary ≤works2.salary ∧ works2.company-name = “Small Bank Corporation”)
ρworks2(works)))

r1-r2
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
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
2
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
0 votes
0 votes
0 answers
3
ajaysoni1924 asked Mar 26, 2019
602 views
DBMS Korth Edition 6 Exercise 6 Question 19 (Page No. 254)
Give a tuple-relational-calculus expression to find the maximum value in relation r (A).
Give a tuple-relational-calculus expression to find the maximum value inrelation r (A).
User Avatar
Link Copied!