Re: Which normal form is this violating?
Date: 6 May 2002 09:40:01 -0700
Message-ID: <c0d87ec0.0205060840.435c6842_at_posting.google.com>
>> People seem to leave more stuff out of their Usenet posts than
Probably is as reasonable; but I like making people think before they
post. Spelling is another matter ...
>> However, the PK-FK approach supports easier modification of the
Hopefully, domains are not constantly changing.
Right now the CREATE/DROP/ALTER DOMAIN statements in Standard SQL are
basically in-line shorthands for column declarations. It is better
than nothing, but not wht it could be. The SQL-99 User Defined Types
are closer to a real domain concept.
My rule of thumb is use CHECK() for small and/or constant domains
their specs, so I figured it was at least equally reasonable to assume
a FK existed. <<
domain, via INSERT and DELETE statements. <<