Re: Table Names: Singular or Plural?

Thank you both. I actually find both of your arguments compelling - and when there are good arguments on both sides of an issue, I tend to think that the isssue might simply be religious. Am I right? Is this just religious?

Let me just add my final two cents...

($.01) As I said in my first post, it massively complicates my life to
transform each entity name to a plural when transforming my logical model to a physical.

($.02) --CELKO--, you're absolutely right that plural names are much more
intuitive when perceiving tables as a SQL programmer would. But, if you're perceiving the tables as a data modeler would, it's my belief that plural names are terribly counterintuitive. More specifically, there are two types of developers: those who are more visual than textual, and those who are more textual than visual. For the first group - those of us who conceive of our databases and object models *visually* as boxes in our heads connected with little lines and arrows - plural names are mighty confusing. For the second group - those who prefer to analyze SQL scripts and source modules - singular names probably seem just as confusing.

After thinking about it, I now beleive it's a matter of perspective. Any thoughts?

--Dave Received on Sat Apr 06 2002 - 00:40:26 CEST