The Most Common Database Design Mistakes - Whats My Name?

By Brian Prince  |  Posted 2008-03-19 Print this article Print
Slide 2

The failure to adopt a naming standard was also cited as a problem, with each developer putting his or her own meaning on column names. Naming standards are a simple solution, with each table name and column name having a common meaning. For example, use column names that end with _date for date columns and _code for coded value columns.


The job of developing a database is not easy, which is why more people don't/can't do it. That said, even the experts make mistakes in the process. After soliciting input from analysts and some professionals in the field, eWEEK has compiled a list of some of the more common database design mistakes and a few general tips for avoiding them.


Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel