Re: CamelCase For Procedures Names

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 22 May 2012 08:26:13 -0700
Message-ID: <CAORjz=NqZ+SYfY6W1ybuqnH3nr8skW3SUrD9wn7D8fyX=2nuUg_at_mail.gmail.com>



On Mon, May 21, 2012 at 12:39 PM, Jeff Chirco <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 - 10:26:13 CDT

Original text of this message