Re: FK -> non PK - bad design?

From: Larry Coon <larry_at_assist.org>
Date: Wed, 09 Apr 2003 11:43:10 -0700
Message-ID: <3E9469BE.48FA@assist.org>

andrewst wrote:

> Is it really worth adding an 'S' to every table name in the world just
> to remind ourselves that there is more than one record in it? If so,
> should we pluralise all the column names too for the same reason - e.g.
> there are many employee names in the "employee_name" column? :)

Besides, I think the "plural table names" argument confuses sets with with they contain. Tables represent sets. The set is singular, for example it is *a* set of employees, i.e., the Employee set. The Employee set (sing.) is a set of Employees (pl.). So why would a singular name lead one to believe that the set contains just one entity?

Larry Coon
University of California
larry_at_assist.org
and lmcoon_at_home.com Received on Wed Apr 09 2003 - 13:43:10 CDT