[Tfug] Any SQL gurus out there?

[Claude Rubinson]

On Thu, Oct 25, 2007 at 02:23:55PM -0700, Don Freeman wrote:
> Maybe we're discussing only semantics. Are you suggesting that a
> lookup table for example should not be part of the database?

Lookup tables should definitely be part of the database.  And the
tables that reference a given lookup table should have referential
integrity to said lookup table.  A lookup table doesn't stand alone.

Another way to think about it: a lookup table defines the possible
instances of an entity.

Claude