Database normalisation

  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

Hi all.

Was surfing for some ASP tutorials and I came across a really cool article. (nothing to do with ASP I might add)

I have noticed that alot of database design done now a days (well locally at least - can't speak for interantion trends) does not adhere to the rules of normalisation and alot of extra code gets written for areas that could be handled by the DBMS.

I seriously recommend that all people new to the programing, database environment give this a read.

http://www.devshed.com/c/a/Administrati ... alization/

May the force be with you.
  • panreach
  • Novice
  • Novice
  • User avatar
  • Posts: 28

Post 3+ Months Ago

Here's a quick easy spectacular database-normalization read:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
  • ProgramMax
  • Newbie
  • Newbie
  • ProgramMax
  • Posts: 12

Post 3+ Months Ago

The second link seemed to be much easier for me to understand.

I had never worked with databases before my current site and so I've kinda reinvented the wheel when it comes to database normalization. Apparently I only made it as far as the 1st form.

Reading through the second link I find it somewhat difficult to identify the fix for 2nd form. I have found that my database isn't 2NF, but I can't quite see how to fix it.

Yikes...kinda scared of what 3NF has in store for me. Good info though guys. Thanks!

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: Liamw411 and 58 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.