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.
ID Name CGPA
B 9.6 3 C 9.2 7 B 9.8
- Q: Select name of students whose CGPA is greater than 9
- Resulting table :
Name B C
- Note:In a set there is no repetition of elements.