Re: CamelCase For Procedures Names

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: JChirco@xxxxxxxxxx
  • Date: Tue, 22 May 2012 08:26:13 -0700

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