Database Management Systems Relational Algebra Cheat Sheet

University of New England (Australia)

Database Management Systems (COSC210)

using relational algebra, we can define data retrieval requests in an
implementation-independent manner through relational algebra expressions
–
many of the constructs from relational algebra are directly
implemented within SQL
○
– SQL should be viewed as an implementation based upon relational algebra
relational algebra provides a formal foundation for the relational model data
manipulation operations
–
it provides a basis for defining the transformations for optimising queries
within the query processing modules in a DBMS
–
relational algebra is focused on the specification of the operations on a
relational database

PREVIEW