--- 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 | | | | |