Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Database Design Question - any suggestion?

Re: Database Design Question - any suggestion?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 9 Dec 2004 15:04:33 -0800
Message-ID: <1102633473.328524.24930@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.
Received on Thu Dec 09 2004 - 17:04:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US