Re: Table Names: Singular or Plural?

>> There are those who insist that table names should be plural. <<

Tables are sets; if you use a plural or collective name, you will treat them as sets. For example:

 Employee = Bad; do you really have at most one guy in the company?

 Employees = Better; it gets you thinking in sets and allows you to consider different types of employees (part-time, full-time, contract, etc.)

 Personnel = Best; it describes the role they play as a class in the data model. Received on Fri Apr 05 2002 - 12:11:01 CST