Converting SQL to relational algebra

sql relational-algebra
user559142 picture user559142 · Apr 24, 2011 · Viewed 58.5k times · Source

Does anyone know any good online resources which I can use to practise SQL to relational algebra conversion?

Answer

Johan picture Johan · Apr 24, 2011

See: http://db.grussell.org/index.html
The following powerpoint presentation may also be of help:
http://www.cs.wayne.edu/~shiyong/csc6710/slides/kiferComp_348761_ppt05.ppt

Related questions

Difference between a theta join, equijoin and natural join

I'm having trouble understanding relational algebra when it comes to theta joins, equijoins and natural joins. Could someone please help me better understand it? If I use the = sign on a theta join is it exactly the same as just …

Read More
What are projection and selection?

What is the difference between projection and selection? Is it: Projection --> for selecting the columns of table; and Selection ---> to select the rows of table? So are projection and selection vertical and horizontal slicing respectively?

Read More
What is the difference between Select and Project Operations

I'm referring to the basic relational algebra operators here. As I see it, everything that can be done with project can be done with select. I don't know if there is a difference or a certain nuance that I've missed.

Read More