Re: Database Design Question - any suggestion?

My hueristic has been that

1. if the values of a constraint are short and do not change often (sex -- not likely to see a new one any time soon) then use a CHECK() constraint,
2. if the values of a constraint are long and/or change often, then use a REFERENCES constraint.
3. if you have a CREATE DOMAIN statement in your product, then use it and the ALTER DOMAIN statement as needed.