This naming convention sees to fit managers, because most programmers cannot figure out the naming convention. A group of Accountants, Lawyers, and Managers must have came up with the [link|http://www.cmsopen.com|CMSOPEN] database. I say this because the whole darn database is located in one database definition and not several. So if you have like 15 terrabytes of information in that database, you might as well throw as much cache RAM as you can into your SQL Server. But on a positive note, their billing and accounting part works great.

Anyway they had table names like "hbm_persnl", "hbm_client", "tbm_matter", etc. I never knew what the three letter acronyms (TLA) stood for before the rest of the name, but I used them anyway.

But working with this database for over 4 years, taught me a lot of things that should not be done with a database.