Relational algebra problem

Posted on April 24, 2011April 24, 2011 by Adrian McMenamin

Have a relational database with the following tables

RESTAURANT(RT_ID, NAME, TYPE, LOCATION)
PROXIMITY(RT1_ID, RT2_ID, DISTANCE)
USER(U_ID, NAME, EMAIL)
REVIEW(U_ID, RT_ID, RT_DATE, RATING, COMMENT)

What’s the relational algebra for “name of any user who has never given Chez Brian a rating lower than 5”?

$\Pi _{NAME} (USER) - \Pi _{NAME} ( \sigma _{RESTNAME='Chez\ Brian' \wedge RATING < 5}( \rho (RESTAURANT(NAME \rightarrow RESTNAME), RESTAURANT) \Join REVIEW) \Join USER)$

Is this right?

CoSQL: SQL and noSQL are really just two sides of the same coin (cacm.acm.org)

Published by Adrian McMenamin

Talk to the hand View all posts by Adrian McMenamin

5 thoughts on “Relational algebra problem”

Pingback: Relational division again | cartesian product
Pingback: Solving a relational query: part 1 | cartesian product
Pingback: Solving a relational query: part 3 | cartesian product
Pingback: Solving a relational query: part 5 | cartesian product
Pingback: Distribution, commutation and association in database queries | cartesian product

Comments are closed.

%d bloggers like this:

Related Articles

Rate this:

Share this:

Like this:

Related

Published by Adrian McMenamin

5 thoughts on “Relational algebra problem”