|
|
Posted by --CELKO-- on 05/03/07 18:28
>> I was taught in school that entity names (tables) should always be in the singular. <<
That was an old DoD standard that started with file names based on the
idea that you read one record at a time, so your unit of work world be
one Order. The conventional wisdom now is that since a table is a
set, you use a collective name when possible or a plural name if you
have to (Personnel, not Employees; Forest, not Trees, etc.)
>> Object prefixes like tbl are okay.<<
No they are not. At best they are a redundancy that screws up the
Data Dictionary. They violate the rule about naming things for their
nature instead of their implementation or usage. And since SQL is
a strongly typed language, they look really silly. Do you put
"noun_" in front of all your nouns to make your sentences easier to
read?
As the ISO-11179 rules get into more meta data repository
requirements, this is going to be important.
Navigation:
[Reply to this message]
|