Relational Data Manipulation (Relational Algebra) | Database Management System

Relational Data Manipulation (Relational Algebra) | Database Management System

Relational Data Manipulation (Relational Algebra) | Database Management System

The Relational Algebra

  1. The relational algebra is a procedural query language. Six fundamental operations:
  • select (unary)
  • project (unary)
  • rename (unary)
  • cartesian product (binary)
  • union (binary)
  • set-difference (binary)

 

  • Several other operations, defined in terms of the fundamental operations:
  • set-intersection
  • natural join
  • division
  • assignment

 

  • Operations produce a new relation as a result.

Formal Definition of Relational Algebra

  1. A basic expression Consists of either
  • A relation in the database.
  • A constant relation.
  1. General expressions are formed out of Smaller Subexpressions using

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management System

 

Relational Data Manipulation (Relational Algebra) | Database Management SystemRelational Data Manipulation (Relational Algebra) | Database Management System