---
# System prepended metadata

title: Relational Algebra
tags: [' Database Theories', ' 必修', NTNU, ' CSIE']

---

---
title: Relational Algebra
tags: NTNU, CSIE, 必修, Database Theories 
---

### Table
| Operation          | Notation | SQL | Defined | Note |
| ------------------ | -------- | --- | ------- | ---- |
| Selection          |          |     |         |      |
| Project            |          |     |         |      |
| Union              |          |     |         |      |
| Set different      |          |     |         |      |
| Cartesian-Product  |          |     |         |      |
| Nature Join        |          |     |         |      |
| Theta Join         |          |     |         |      |
| Left Outer Join    |          |     |         |      |
| Right Outer Join   |          |     |         |      |
| Full Outer Join    |          |     |         |      |
| Aggregate Function |          |     |         |      |
