Please enable JavaScript.
Coggle requires JavaScript to display documents.
RELATIONAL ALGEBRA - Coggle Diagram
RELATIONAL ALGEBRA
Procedural query language
BASIC OPERATORS
SELECT
Select tuples from a relation based on some condition
PROJECT
Project particular columns from a relation
CROSS PRODUCT
Join two relations
UNION
combine the results of two or more SELECT statements
SET DIFFERENCE
Returns the values that are in the first set but not the second set.
RENAME
Give another name to a relation
EXTERNAL OPERATORS
INTERSECTION
JOIN
Conditional Join
Equi Join
Natural Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
DIVIDE
ADVANTAGES
Flexibility
Precision
DISADVANTAGES
Performance
Physical Storage Consumption
IMAGE ANALOGY
UNION OPERATOR
SET DIFFERENCE
INTERSECTION
