For my recent designs, I've been using an identity column as the PK (which, if my understanding is correct, is called a surrogate key), and at least one candidate key,...
I should clarify: I understand how cascading deletes are used (to automatically delete child rows when a parent row is deleted), but I was less clear on when or if...