Your Dilemma - Option A:

Execute everything possible using database features
- user data types, not null, triggers, etc.
Thus fragmenting behaviors of business rule into many pieces.