Relational Algebra Operations in SQL with Examples

Share this post!

Vote this!

Relational Algebra

   A query language is a language in which user requests information from the database. it can be categorized as either procedural or nonprocedural. In a procedural language the user instructs the system to do a sequence of operations on database to compute the desired result. In nonprocedural language the user describes the desired information without giving a specific procedure for obtaining that information.

The relational algebra is a procedural query language. It consists of a set of operations that take one or two relations as input and produces a new relation as output.

Fundamental Operations

• SELECT
• PROJECT
• UNION
• SET DIFFERENCE
• CARTESIAN PRODUCT
• RENAME

More...