Re: Database Design Question - any suggestion?
Date: Fri, 10 Dec 2004 08:28:14 +0100
Message-ID: <cpbj1i$54h$1_at_news.net.uni-c.dk>
"-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 - 08:28:14 CET