Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table Design In General
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
![]() |
![]() |