The Most Common Database Design Mistakes - Just What Is Normal?

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

When it comes to OLTP, poor normalization can hurt data integrity and performance. Be cognizant of the 3NF (third normal form), and use model validation tools to detect normalization issues. A technical walk-through of the model by someone other than the modeler helps, too.


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