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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Normalization, Natural Keys, Surrogate Keys

Re: Normalization, Natural Keys, Surrogate Keys

From: Sebastiano Pilla <etechweb_at_yahoo.com>
Date: Wed, 22 May 2002 21:33:54 +0200
Message-ID: <1fcjyzg.14kmx3a14jlmqwN%etechweb@yahoo.com>


Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

> "Sebastiano Pilla" <etechweb_at_yahoo.com> wrote in message
> news:1fce03i.1tn2z99142zkg0N%etechweb_at_yahoo.com...
> > Pablo Sanchez <pablo_at_dev.null> wrote:
> >
> > > (btw, you should use singular rather than plural for table names.
> > > <g>)
> >
> > Slightly tangential to the thread in case, and all-seriouts question:
> > why?
> Because the ocurrences of the entity are named plural.
> So you have an entity EMPLOYEE and the ocurrences of the entity are called
> EMPLOYEES.
That's what I was expecting, and it makes sense; however I've always used the opposite reasoning: each row of EMPLOYEES represents a single EMPLOYEE, so usually my table names are plural.

In the end I don't think it matters that much, as long as one sticks to one convention and uses it consistently.

Sebastiano Pilla Received on Wed May 22 2002 - 14:33:54 CDT

Original text of this message

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