Relational Algebra Playground
Pick an operator, choose relation(s), and watch the result compute instantly. Great for checking your hand-worked answers.
Keep rows matching a predicate.
σ[ Department = CSE ] (STUDENT)
Input
| StudentID | Name | Department | Year | |
|---|---|---|---|---|
| S001 | Rahim Ahmed | CSE | 2 | rahim@uni.edu |
| S002 | Karim Hasan | EEE | 3 | karim@uni.edu |
| S003 | Nusrat Jahan | CSE | 1 | nusrat@uni.edu |
Result
| StudentID | Name | Department | Year | |
|---|---|---|---|---|
| S001 | Rahim Ahmed | CSE | 2 | rahim@uni.edu |
| S003 | Nusrat Jahan | CSE | 1 | nusrat@uni.edu |
Try these: σ on STUDENT where
Department = CSE · π Name, Email · r ∩ s on the two (A,B) relations · r ⋈ s on r(A,B,C,D) and s(B,D,E).