naming conventions?

Hi,

I am trying to find a definitive set of naming conventions for databases 
and McKoi in particular. I can't seem to turn anything up using google 
and searching through the McKoi documentation. I find that different 
people have different thoughts - for example

/"//Table names should be plural, for example, "Customers" instead of 
"Customer". This rule is applicable because tables are logical 
collections of one or more entities as records - just like collection 
classes are logical collections of one or more objects."

/ and

/"give tables singular names, never plural /

    * /promotes consistency with naming of primary key fields and lookup
      tables /
    * /ensures alphabetical ordering of a table before its lookup or
      linking tables /
    * /avoid confusion of english pluralization rules to make database
      programming easier (e.g. activity becomes activities, box becomes
      boxes, person becomes people, data remains data, etc.) /
    * /more grammatical SQL (e.g. SELECT activity.activity_name --rather
      than-- SELECT activities.activity_name)"/

I also find confusion over the use of naming with underscores or 
capitials between words (table_name vs tableName).

Is this all just a matter of personal preference or are there any rules? 
If there are rules then can anyone point me to where they are recorded?

many thanks

Iain.


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]