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: Tobin Harris <comedyharris_at_hotmail.com>
Date: Sat, 18 May 2002 08:58:45 +0100
Message-ID: <ac51fd$mk6ki$1@ID-135366.news.dfncis.de>


> (btw, you should use singular rather than plural for table names.
> <g>)

He he. This cropped up recently on comp.databases, where Joe Celko was saying the opposite! I quite like singular table names, but he was saying that collective nouns (e.g Personelle) were favourable, and failing that plural nouns (Employees). Apparently this is part of the ISO (?) standard. The argument seemed to be that if the table is to hold more than one Employee, then it should be called Employees.

I still prefer singular <g>. What's funny, and a little annoying IMHO, is that noone can agree on *anything*! There always seems to be more than one 'correct' way of doing something, and strong but different arguments for each. That's probably why standards are good - let someone else decide for us!

Tobin Harris

> --
> Pablo Sanchez, High-Performance Database Engineering
> mailto:pablo_at_hpdbe.com
> http://www.hpdbe.com
> Available for short-term and long-term contracts
>
>
Received on Sat May 18 2002 - 02:58:45 CDT

Original text of this message

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