State fundamental.operations in the relational.algebra and explain.with example
Answers
Answered by
0
The fundamental operations of relational algebra are as follows −
Select-
It selects tuples that satisfy the given predicate from a relation.
Project-
It projects column(s) that satisfy a given predicate.
Union-
It performs binary union between two given relations
Set difference-
The result of set difference operation is tuples, which are present in one relation but are not in the second relation.
Cartesian product-
Combines information of two different relations into one.
Rename
The results of relational algebra are also relations but without any name. The rename operation allows us to rename the output relation.
Select-
It selects tuples that satisfy the given predicate from a relation.
Project-
It projects column(s) that satisfy a given predicate.
Union-
It performs binary union between two given relations
Set difference-
The result of set difference operation is tuples, which are present in one relation but are not in the second relation.
Cartesian product-
Combines information of two different relations into one.
Rename
The results of relational algebra are also relations but without any name. The rename operation allows us to rename the output relation.
Similar questions