RE: CamelCase For Procedures Names

From: <>
Date: Tue, 22 May 2012 13:57:30 -0400
Message-ID: <>

Out of curiousity, I did an informal survey of my databases, most of which were third party and they are all singular table names. Peoplesoft, Lawson, Sterling, and a couple custom. I guess I just like saying the Employee table as opposed to the Employees table.... But I'll keep an open mind and see if I can find more examples and discourse. I am not sure at this point if I would change the standard. I certainly cannot change the models in any of the existing databases... and don't wish to have a mix. Hmmm.

Joel Patterson
Database Administrator
904 727-2546
From: Jared Still [] Sent: Tuesday, May 22, 2012 11:26 AM
Cc: Patterson, Joel; oracle Freelists
Subject: Re: CamelCase For Procedures Names

On Mon, May 21, 2012 at 12:39 PM, Jeff Chirco <<>> wrote: Really, I feel table names should be plural. I believe Steve Feuerstein recommends this too. It is a Table of EMPLOYEES not a Table of EMPLOYEE.

This was also the recommendation of Richard Barker, of CASE*Method fame.

When designing data models, entities are singular to emphasize that what is being described is a single instance of data.

Tables are plural, as they are a collection of the instances described by entities in the model.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

Received on Tue May 22 2012 - 12:57:30 CDT

Original text of this message