8 Years
Discussion Span
Last Post by pclfw

3nf is industry standard normal form, you will not find any problem in inserting,deleting and updating a row if ur table is in 3nf.


Normalization is actually fairly simple. To convert data from one form to another you apply a single, simple, rule to that data. To move to the next level of normalization apply the next rule etc. etc. See http://en.wikipedia.org/wiki/Database_normalization.

So examine your data and see if it conforms to these rules. If it does then it is normalized. If it doesn't then it is not.

However reducing data into its 3rd normal form does not necessarily make it totally suitable for use within a DB. You then have to OPTIMIZE the data. During this exercise you may denormalize parts of the data to give faster access to the information. So you now have to go back to your DB designer and ask what were the decisions made in the normalization & optimization of the data.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.