Member Avatar for CodeBoy101

Hi guys I was wondering, how to prove that your tables are in 1NF, 2NF and 3NF?
Thanks.

  • 3 Contributors
  • 2 Replies
  • 135 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by pclfw
Member Avatar for Majestics

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.

Member Avatar for pclfw

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.