9

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

user559142
  • 12,279
  • 49
  • 116
  • 179
  • SQL is the most common way to express [relational algebra](http://en.wikipedia.org/wiki/Relational_algebra) on a computer. What kind of language would you convert it to? – Andomar Apr 24 '11 at 15:37
  • possible duplicate of [SQL -> Relational Algebra](http://stackoverflow.com/questions/5771490/sql-relational-algebra) – Andomar Apr 24 '11 at 15:45
  • I just want to be able to express an SQL statement as in its relational algebraic form (using selection, projection, intersection, union etc) – user559142 Apr 24 '11 at 16:09
  • 2
    @Andomar, not a duplicate of that question. This ask a general question, the other an example SQL statement for a given query. – Johan Apr 24 '11 at 16:36

2 Answers2

9

The online tool RelaX will allow you to convert SQL to Relational Algebra. You can also compose and execute relational algebraic expressions on small datasets.

Frank Haubenreisser
  • 337
  • 4
  • 14
mstahl
  • 353
  • 3
  • 6
9

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

Johan
  • 74,508
  • 24
  • 191
  • 319
  • 1
    Half answers the question. +1 nonetheless for good sources. The sources don't explain how to convert aggregate SQL operators (like GROUP BY) to RA, which is what I was looking for. – CodyBugstein Dec 29 '13 at 22:36