The Most Common Database Design Mistakes - Whats My Name?

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

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.

 
 
 
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.


 
 
 
 
 
 
 
 
 
 
 

Submit a Comment

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























 
 
 
 
 
 
 
 
 
Rocket Fuel