Content covered: 

Working of PROJECT operation in Relation Algebra

  • Select and Project are unary operations, that works on a single relation.
  • Select and Project are commutative in nature.
  • Example:
    ID Name CGPA

    2

    B 9.6
    3 C 9.2
    7 B 9.8
  • Q: Select name of students whose CGPA is greater than 9
    A:σnameCGPA>9(Student)]
  • Resulting table :
    Name
    B
    C
  • Note:In a set there is no repetition of elements.