Pk

Is this statement true: Records are never deleted from the parent tables, and primary keys are never updated in the parent tables.

what?

makes no sense, why wouldn't data be deleted or updated

True that the PK itself should generally not ever be updated, but there is no reason whatsoever it can't be deleted. How does on delete cascade work for FKs?