Relational Algebra Tutorial

Database | Home











 


The set intersection operation is denoted by the symbol . It is not a fundamental operation, however it is a more convenient way to write r - (r - s).

An example query of the operation to find all customers who have both a loan and and account can be written as:

customer-name (borrower) customer-name (depositor)

The results of the query are the following:

customer-name

Hayes
Jones
Smith

 

Database | Home | Top of page