> names. Tables contain a set of data. What's in a table describing
> people? If you ONLY store one person, then it is a person table. If
> it stores more than one person, it is storing people. Typically,
> tables contain more than one record; hence they typically should be
> named as a plural
While I personally prefer singular table names, I think this is one of those
cases where your choice really doesn't matter at all, as long as you're
consistent. I disagree with Joe Celko's reasoning on this, as a table
corresponds to an entity in a logical data model (and entities are by their
very nature singular), but it just doesn't matter.
Next up: K&R or BSD curly braces in C - which are better?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
