Database Normalization
Even a good database design can't always protect against bad data. But there are plenty of occasions when a good database design helps us avoid the bigger of the possible bad data - database headaches. Thus, in this article I'll discuss database normalization: what it is, why we do it, and how we do it. I'll also discuss how we can determine when a database table is normalized 'enough' and what indications we can look for that suggest bad data might pose a problem for our database.