Does anyone know any good online resources which I can use to practise SQL to relational algebra conversion?
Converting SQL to relational algebra [closed]
Asked Answered
SQL is the most common way to express relational algebra on a computer. What kind of language would you convert it to? –
Intermezzo
possible duplicate of SQL -> Relational Algebra –
Intermezzo
I just want to be able to express an SQL statement as in its relational algebraic form (using selection, projection, intersection, union etc) –
Buzzer
@Andomar, not a duplicate of that question. This ask a general question, the other an example SQL statement for a given query. –
Flawed
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
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. –
Hackbut
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.
© 2022 - 2024 — McMap. All rights reserved.