CSCE 4523 DBMS – Midterm Study Guide

Why is it called an algebra? Relational closure. Project, select, join (theta, outer, natural), union, intersection. Aggregation operators like Sum, Average. Views. Triggers . Relational Calculus – SQL – Chapter 3, 5. Why is it called a calculus? Data definition language - Create/Alter/Drop {catalog, schema, table, view, domain} ................
................