Ex1 ... aggregates (product, cat, mycount) Ex2 ... trigger to implement foreign key checking Ex3 ... trigger to maintain student counts in Classes