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: 213



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: 20th December 2014 - 10:01 AM