hi,
how many Normalizations in mysql to create db. if you know any urls. please forward to me.
please help to me.
thanks,
qumar.
how many Normalizations
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: how many Normalizations
I'm not sure I know what you are asking. Normalization is a process that is used to help structure the tables of any relational database. Perhaps you are referring to the numbered Normal Forms defined by E.F. Codd and Chris Date in the 1960's. For a database to be reliable and efficient, it should meet the requirements of Second Normal Form, at a minimum. All that means is that your tables have no repeating fields or groups, and that all non-key fields are dependent on the primary key. Beyond that, there are several more Normal Forms, but there is no rule that says how "normalized" any database must be. It depends on a host of factors far too complex to permit a general answer. Here's a fairly good explanation of Normal Forms: http://trumpetpower.com/Papers/Normal_Formsqumar wrote:hi,
how many Normalizations in mysql to create db. if you know any urls. please forward to me.
please help to me.
thanks,
qumar.
-
sunilbhatia79
- Forum Newbie
- Posts: 24
- Joined: Sun Nov 11, 2007 9:37 pm
- Location: Mumbai, India
I agree with califdon and aceconcepts... as a matter of fact at times (actually many times when doing MIS type of reporting and projects) you will have to denormalize your tables.
It all depends on the application that you develop and the trade off that you want to choose between speed v/s space.
Sunil
It all depends on the application that you develop and the trade off that you want to choose between speed v/s space.
Sunil