how many Normalizations

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
qumar
Forum Commoner
Posts: 29
Joined: Wed Nov 01, 2006 8:20 am

how many Normalizations

Post by qumar »

hi,
how many Normalizations in mysql to create db. if you know any urls. please forward to me.
please help to me.
thanks,
qumar.
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Post by aceconcepts »

It really depends on your database and data model.

Use a search engine to find example of how to normalise your tables - there are lots of tutorials out there.

Or

Give some more insight into your problem.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: how many Normalizations

Post by califdon »

qumar 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.
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_Forms
sunilbhatia79
Forum Newbie
Posts: 24
Joined: Sun Nov 11, 2007 9:37 pm
Location: Mumbai, India

Post by sunilbhatia79 »

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
Post Reply