Re: Database naming convention (yet another post of it, but a bit different)

71062.1056_at_compuserve.com (--CELKO--) wrote:

>>> ... to propose my own naming convention and to see if someone can
>point out some concept errors or may be propose some rules I didn't.
><<
>
>Use the ISO 11179 Metadata Standards for naming data elements instead
>of inventing your own.
>
>>> 1) tables names are in singular .. <<
>
>No. A table is a set of entities. A singular name is bad; a plural
>name is better; a collective noun is best. Example:
>
> Employee = bad
> Employees = better
> Personnel = best
>
> Tree = bad
> Trees = better
> Forrest = best

  ^^^^^^^
     Gump!

     Thing
     Things
     Stuff

     I prefer singular myself.

[snip]

>>> 5) Do not abbreviate! <<
>
>Yes. But allow for only common abbreviations or those used in the
>trade. Every American knows "ssn" is "Social Security Number", every
>Canadian knows "sin" is "Social Insurance Number", etc.

     I love good abbreviations.

[snip]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.