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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database Design

Re: Database Design

From: Van Messner <vmessner_at_bestweb.net>
Date: 2000/06/15
Message-ID: <_ud25.567$pg7.54389@newshog.newsread.com>#1/1

I couldn't understand everything you tried to say. As a general rule if you have tables where the primary key has no use, then you have a bad database design.

Van

<stephenjensen_at_my-deja.com> wrote in message news:8ibkn9$iia$1_at_nnrp1.deja.com...
> In my work experience several fields are put together to make up a
> primary key. Basically it is known that the combination of these fields
> will be unique. I have no problem with this if the combination of these
> fields (Primary Key) will be used as a way of accessing a row. However,
> it is known the primary key (Combination of Fields) will not be used to
> access a row. The fact of the matter is you plan to be able to select a
> single to multiple rows back using one of these two fields that make up
> the primary key, but never the two fields together (Primary Key). The
> Primary Key becomes purely academic with no practical use. Therefore, is
> this a bad database design?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jun 15 2000 - 00:00:00 CDT

Original text of this message

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