Relational Algebra (Selection, Projection,Cartesian Product, Union, Intersection, Difference, )
Channel: NETCracker CBSE NET/ GATE Computer Sc.
Date: 2017-12-07

Relation Algebra provide various operators for manipulating data in the tables.
Relational Algebra operations
1. Union:helps to combined two tables.
2. Intersection: display common tuples present in both the tables.
 3.Difference: display tuples present in first table only.
4. Cartesian Product: combined two tables by pairing each tuple of first table with the every other tuple of second table.
5. Selection: display the tuples which satisfy the selection condition.
6.Projection:display the attributes which satisfy the projection condition.
7.Joins: helps to combined two tables.
8.Division