Re: identity columns

"Jan Emil Larsen" <jel_at_g-it.dk> skrev i en meddelelse news:a1bj9i$l9k$1_at_news.net.uni-c.dk...
>
> "--CELKO--" <71062.1056_at_compuserve.com> skrev i en meddelelse
> news:c0d87ec0.0201060830.610c4a90_at_posting.google.com...
> > >> There seems to be a lot of talk in this NG about the good, bad and
> > ugly
> > aspects of primary keys - especially Identity columns. <<
> >
> > First, I would name the table "Personnel" and not "Employee" -- it is
> > a set, so you want a plural or collective noun, not a singular
> > (scalar) one.
>
> I disagree.
> The entity type and the base table derived from it should by named as an
> abstract representation of its instances, thus a singular noun, such as
> Employee.
> Consult Date or another standard textbook.

Oh boy, by inspection I must correct to: Consult a standard textbook, except "Date: An introduction....". For some reason Date seem to use plural, while "most others" use singular, eg: Elmasri & Navathe: "...use singular names for entity types, rather than plural ones, because the entity type name applies to each individual entity ....".

We migth take a vote on it <g> ... Received on Mon Jan 07 2002 - 18:08:03 CET