Complete Computer Knowledge Portal

Saturday, March 30, 2013

Difference Between Relational Algebra and Relational Calculus

Sr. No.
Relational Algebra
Relational Calculus
1
It is Procedural query language.
It is non-procedural query language.
2
It deals with what to do and how to do.
It only deals with how to do.
3
It consists of a set of operations that take one or two relations as input and produces a new relation as the output.
In relational calculus, we must write a sequence of operations to specify a retrieval relation.
4
The Fundamental operation in Relational-Algebra are: Select, Project, Union,natural join etc.
The Operations in Relational Calculus are: Tuple relationship
calculus and Domain Relational calculus.

No comments:

Post a Comment