UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Relational Algebra Help    
 
   
asiandoll
post Oct 18 2011, 06:34 PM
Post #1

UtterAccess Enthusiast
Posts: 79



I everyone,
I have created a query in SQL, can anyone help me create it in relational algebra? I am trying to understand it.
SELECT Eats.name, Eats.pizza, Serves.price, Serves.pizzeria
FROM Serves INNER JOIN (Eats INNER JOIN Person ON Eats.name = Person.name) ON Serves.pizza = Eats.pizza
WHERE (((Eats.name)="amy") AND ((Serves.price)<10)) OR (((Eats.name)="fay") AND ((Serves.price)<10));
Thanks.
Go to the top of the page
 
+
khalakmu
post Oct 18 2011, 08:07 PM
Post #2

UtterAccess Addict
Posts: 199



amy or fay eats Pizza at pizzeria cost price is than 10 (cent ) acclaim.gif
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 23rd September 2014 - 09:25 PM