Relational Algebra | Relational Algebra in DBMS

Relational Algebra-

 

Relational Algebra is a procedural query language which takes a relation as an input and generates a relation as an output.

 

Relational Algebra Operators-

 

The operators in relational algebra may be classified as-

 

 

We will discuss all these operators one by one in detail.

 

Characteristics-

 

Following are the important characteristics of relational operators-

 

  • Relational Operators always work on one or more relational tables.
  • Relational Operators always produce another relational table.
  • The table produced by a relational operator has all the properties of a relational model.

 

Next Article- Selection Operator in Relational Algebra

 

Get more notes and other study material of Database Management System (DBMS).

Watch video lectures by visiting our YouTube channel LearnVidFun.

Summary
Relational Algebra | Relational Algebra in DBMS
Article Name
Relational Algebra | Relational Algebra in DBMS
Description
Relational Algebra is a procedural query language which takes relation as input and generates relation as output. Relational Algebra Operators and Characteristics of Relational Algebra Operators.
Author
Publisher Name
Gate Vidyalay
Publisher Logo