RE: CamelCase For Procedures Names
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, <JChirco@xxxxxxxxxx>
- Date: Tue, 22 May 2012 13:16:01 -0400
Well I googled around and didn't find Richard Barker deal with the names, but I
did find that he was Brit, followed by this quote on stackoverflow (which the
closer I read it the more it seems the sentence contradicts itself - I think
the hypothesis should reference an American using a singular noun - which could
explain a lot -- c'est la vie).
In British English, a collective object is often grammatically plural, e.g.,
"the committee were unable to agree" versus American English "the committee was
unable to agree". So I hypothesized that a Brit might be more willing to use a
singular noun for a collection of things. -
Ken<http://stackoverflow.com/users/82793/ken> May 1 '09 at
20:03<http://stackoverflow.com/questions/808992/singular-or-plural-database-table-names#comment622606_809006>
:) (just keeping it light).
Joel Patterson
Database Administrator
904 727-2546
From: Jared Still [mailto:jkstill@xxxxxxxxx]
Sent: Tuesday, May 22, 2012 11:26 AM
To: JChirco@xxxxxxxxxx
Cc: Patterson, Joel; oracle Freelists
Subject: Re: CamelCase For Procedures Names
On Mon, May 21, 2012 at 12:39 PM, Jeff Chirco
<JChirco@xxxxxxxxxx<mailto:JChirco@xxxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
