Re: Normalization, Natural Keys, Surrogate Keys

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 - 21:33:54 CEST