 Access to 800,000+ Textbook Solutions
 Ask any question from 24/7 available
Tutors  Live Video Consultation with Tutors
 50,000+ Answers by Tutors
For each of the following pairs of expressions give instances
For each of the following pairs of expressions, give instances of relations that show the expressions are not equivalent.
a. ΠA(R − S) and Π A (R) – ΠA (S)
b. σB < 4(AGmax(B)(R)) and AGmax(B)(σB<4(R))
c. In the preceding expressions, if both occurrences of max were replaced by min would the expressions be equivalent?
d. (R Θ S) Θ T and R Θ (S Θ T)
In other words, the natural left outer join is not associative.
e. σθ (E1 Θ E2) and E1 Θ σθ (E2), where θ uses only attributes from E2
a. ΠA(R − S) and Π A (R) – ΠA (S)
b. σB < 4(AGmax(B)(R)) and AGmax(B)(σB<4(R))
c. In the preceding expressions, if both occurrences of max were replaced by min would the expressions be equivalent?
d. (R Θ S) Θ T and R Θ (S Θ T)
In other words, the natural left outer join is not associative.
e. σθ (E1 Θ E2) and E1 Θ σθ (E2), where θ uses only attributes from E2
Membership
TRY NOW
OR
Relevant Tutors available to help

Christine Kanyaa
business management

Caroline Njeri
Business Administration

Keziah Thiga
Business Management