[prev] 36 [next]

Relational Algebra Operations (cont)

Intersection
  • r1 ∩ r2   =   { t  |  t ∈ r1 ∧ t ∈ r2 },     where r1(R), r2(R)
Computational view: 

result = {}
for each tuple t in relation r1
    if (t ∈ r2) { result = result ∪ {t} }