Set Operations UNION, INTERSECTION, MINUS
Set Operations UNION, INTERSECTION, MINUS
UNION
Set operations (attributes naming)
CARTESIAN PRODUCT Operation (CROSS PRODUCT)
CARTESIAN PRODUCT Operation
CARTESIAN PRODUCT Operation
CARTESIAN PRODUCT Operation
Binary Operation θ-JOIN
General form of θ-JOIN
NATURAL JOIN
759.89K
Category: programmingprogramming
Similar presentations:
Analysis and Design of Data Systems. Relational Algebra (Lecture 17)
Analysis and Design of Data Systems. Relational Algebra (Lecture 17)
Analysis and Design of Data Systems. Complex SQL Queries (Lecture 13)
Analysis and Design of Data Systems. Complex SQL Queries (Lecture 13)
Data. Structures in Python for Data analysis. lecture 2
Data. Structures in Python for Data analysis. lecture 2
Set Theory
Set Theory
Oracle SQL basics, the select statement
Oracle SQL basics, the select statement
2. Java Basics. Data Types
2. Java Basics. Data Types
Analysis and Design of Data Systems. Functional Dependencies and Normalization Theory (Lecture 15)
Analysis and Design of Data Systems. Functional Dependencies and Normalization Theory (Lecture 15)
Course object oriented programming lecture 2
Course object oriented programming lecture 2
IT System analysis: system analysis approaches
IT System analysis: system analysis approaches
Analysis and Design of Data Systems. General Definitions of 2NF & 3NF Boyce-Codd Normal Form (Lecture 16)
Analysis and Design of Data Systems. General Definitions of 2NF & 3NF Boyce-Codd Normal Form (Lecture 16)

Analysis and Design of Data Systems. Relational Algebra 2 (Lecture 18)

1.

IE301
Analysis and Design of Data Systems
Lecture 18
Relational Algebra 2
Aram Keryan
November 16, 2015

2. Set Operations UNION, INTERSECTION, MINUS

The next group of relational algebra operations are the standard
mathematical operations on sets.
MINUS
UNION
A
B
A
INTERSECTION
B
A
B

3. Set Operations UNION, INTERSECTION, MINUS

UNION, INTERSECTION, and MINUS are binary operations.
Let’s
English     Русский Rules