>>BTW, some database experts prefer to use plural for table names.
>>
>>And some prefer singular. Andy is an expert SQL Server developer and DBA and he prefers singular. As a matter of fact, he says that all of the SQL Server developers he knows prefer singular.
>
>"All"? That's a pretty big word. :)
>
>And again, the use of the word "preference". :)

Isn't the rationale behind using singular that you refer to the "record structure" (I guess these days you would call it an entities) rather than to the contents of the table (i.e. its records). I have found that the rationale helps enforcing the singular naming convention, whether that is intuitive, with retrospect, I'm less sure.

Table names like "inventory" or "ledger" are singular alright, but they are also fuzzy.