[Tfug] Any SQL gurus out there?

[Don Freeman]

Yes but that's my point. A lookup table is not technically a "related"
table. 


Don W. Freeman, P.E.
Transportation Engineer
Pima Association of Governments
177 N. Church Ave. #405
Tucson AZ 85701
(520) 792-1093 voice
(520) 620-6981 fax

-----Original Message-----
From: tfug-bounces at tfug.org [mailto:tfug-bounces at tfug.org] On Behalf Of
Claude Rubinson
Sent: Thursday, October 25, 2007 3:16 PM
To: tfug at tfug.org
Subject: Re: [Tfug] Any SQL gurus out there?

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

_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org