The Most Common Database Design Mistakes - Whats My Name?
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.