Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: No future for DB2 - slightly off-topic, discusses what people are being taught at uni
"rkusenet" <rkusenet_at_yahoo.com> wrote:
> > So creating an index on a foreign key should not be automatic.
> While I agree with you, I would add that for code lookups like Title (Mr,
> Mrs, Ms) I would rather go with a check constraint than a FKY. Anything with a low
> cardinality and known static values should be handled in a check constraint. At least I
> would.
Yes, but Title is a classic example of where it's not static. What about Fr., Rev., Maj., Capt., Col., Gen., Sr., Sir, Lord, Madame, Master, Miss, Rev., H.(is/er) E.(xcellency) and that's only in English?
If you're writing an app for a bilingual or trilingual country, the number of possibilities is beyond a simple check constraint, which is suited to the likes of Gender, but not a title field.
Paul...
-- plinehan __at__ yahoo __dot__ __com__ XP Pro, SP 2, Oracle, 9.2.0.1.0 (Enterprise Ed.) Interbase 6.0.1.0; When asking database related questions, please give other posters some clues, like operating system, version of db being used and DDL. The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks. Furthermore, as a courtesy to those who spend time analysing and attempting to help, please do not top post.Received on Mon Aug 01 2005 - 04:40:00 CDT
![]() |
![]() |