Skoči na vsebino

RELATIONAL ALGEBRA

Fundamental Relational Algebra Operations

  1. Six fundamental operations

    • σ select operation
    • Π project operation
    • ∪ set-union operation
    • – set-difference operation
    • × Cartesian product operation
    • ρ rename operation

  2. Each operation takes one or two relations as input

  3. Produces another relation as output
  4. Important details:
    • What tuples are included in the result relation?
    • Any constraints on input schemas? What is schema of result?
Zadnja posodobitev: March 27, 2022