Re: Database Design Question - any suggestion?

"-CELKO-" <jcelko212_at_earthlink.net> skrev i en meddelelse news:1102633473.328524.24930_at_f14g2000cwb.googlegroups.com...
> 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.

OK.
We agree that (2) is a suitable and (the only) general solution which keeps the schema intact (if that is an issue). As a customer I would prefer (2), and as a supplier (consultant) I migth offer (1) or (3) ...:-).

From a theoretical point (and we are in c.d.t), would you agree that (2) is the correct "solution"? Received on Fri Dec 10 2004 - 01:28:14 CST