Tom Kelliher, CS 318
Mar. 11, 2002
E/R design.
Queries in relational algebra, SQL, and TRC.
Key constraints (candidate and primary keys). Foreign keys and referential integrity.
GROUP BY
and HAVING
.
Conversion to relational model.