RE: CamelCase For Procedures Names

From: <Joel.Patterson_at_crowley.com>
Date: Tue, 22 May 2012 13:57:30 -0400
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1B95AAEFBE_at_JAXMSG01.crowley.com>

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 [mailto:jkstill_at_gmail.com] Sent: Tuesday, May 22, 2012 11:26 AM
To: JChirco_at_innout.com
Cc: Patterson, Joel; oracle Freelists
Subject: Re: CamelCase For Procedures Names

On Mon, May 21, 2012 at 12:39 PM, Jeff Chirco <JChirco_at_innout.com<mailto:JChirco_at_innout.com>> 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: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

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