Normalization? What must I do?
Moderator: General Moderators
Normalization? What must I do?
Since I've gotten into mySQL, some people told me that I should read about normalization, in order to avoid future maintenance errors in the database. The problem is I don't clearly understand what exactly I should do on my end to ensure the integrity of my database? Add multiple checks in submission forms before data gets into the database? Organise the data in many separate tables? Install maintenance software?
Re: Normalization? What must I do?
There are 10 types of people in this world, those who understand binary and those who don't
Re: Normalization? What must I do?
There's also a good article on MySQL's site:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
To answer your questions in a nutshell: yes (but this has nothing to do with normalization), probably, not necessary.
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
To answer your questions in a nutshell: yes (but this has nothing to do with normalization), probably, not necessary.
Re: Normalization? What must I do?
Normalization has nothing whatsoever to do with the data that is entered, it is concerned with what fields are created in a table, which is a one-time job (but very important). You seem to be describing data validation.
Anyway, the clearest article I've read on normalization is at http://www.phlonx.com/resources/nf3/.
Anyway, the clearest article I've read on normalization is at http://www.phlonx.com/resources/nf3/.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Re: Normalization? What must I do?
That is a good articlecalifdon wrote:Normalization has nothing whatsoever to do with the data that is entered, it is concerned with what fields are created in a table, which is a one-time job (but very important). You seem to be describing data validation.
Anyway, the clearest article I've read on normalization is at http://www.phlonx.com/resources/nf3/.