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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Design In General

Re: Table Design In General

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 18 May 2005 21:15:32 +0200
Message-ID: <d6g408$2s7$1@news2.zwoll1.ov.home.nl>


Chris wrote:
> Ed,
>
> Thanks for the input. I am most definitely in contact with the DBA who
> will be over-seeing the database. He is in favor of the "dumb" key
> concept. here is the reasonig behind our logic.
>
> In this industry (music & entertainment distribution), the
> manufacturers assign a "part number" to their products as a way of
> uniquely identifying them. In our own product table, if we were to use
> that part number as the intelligent key to our product table, we would
> run into a problem because the part numbers actually change (more often
> than you would imagine).

Darn! My Elvis LP just turned into a widget! Part numbers don't change.

-- 
Regards,
Frank van Bortel
Old golfers don't die - they just loose their balls.
Received on Wed May 18 2005 - 14:15:32 CDT

Original text of this message

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