• I've gone back back and forth on the singular v. plural table names argument.  In the early days when I was a systems analyst, I was taught that table names should be singular because entity type names where named singularly.  Well I changed my mind in the last 2 or 3 years because a table is collection of instances, and it makes more sense to refer to a collection in the plural.

    As for the "we don't do it that way with OO" argument, I must admit surprise that someone would try project an object oriented programming standard onto a relational database object.

    For good discussion on general SQL naming conventions, including plurals see: http://www.dbazine.com/db2/db2-disarticles/gulutzan5

    Regard all - Todd