Read my highly-acclaimed tutorial on the Three Normal Forms.
Download a printable PDF version of this tutorial.
Then come back here and leave a comment, if you want.
For the record, I don’t have any tutorials on 4th Normal Form, 5th Normal Form, Boyce-Codd Normal Form, or any other Forms (normal or otherwise) you might wish to ask about. Thanks, and happy reading!
I am a DBA, now reading this article really thrilled me.
I loved every peice of it.
Doubt which came to me as a DBA regarding performance were addressed beautifully.
All possible doubt were covered and beautifull knitted, because of which reader don’t loose interest.
Superb Keep it up.
Also, I wanted to have a PDF for future reference that was also taken care.
Its suits my requrement completely.
Thank You
OMG…After reading sooo many books, asking questions to the instructor, and viewing multiple websites, I still was confused on what to do for the 3 norms of a database. Your tutorial explained exactly what I was supposed to do without all that extra stuff. Cheers!!!
Hey!!
I have been having so many confusions in understanding normalization, but after going through your tutorial I feel confident that I am now clear on the topic.
Thank you for the excellent step-by-step discussion. I had used these concepts for some time but never really understood how they related to the “3rd normal form” and its concepts.
Thanks!
Dear Fred,
Aftr so many years I really found a good stuff of explanation on the Three Normal Forms.Got my all doubts on Normal Forms cleared. Thanks a lot
Hello Fred,
The example you gave is really nice.
Thank you very much for providing such a good example.
Keep continuing the same work.
Hi Fred,
I referred numerous books and sites to understand the three forms of Normalization.The best part about the example you have provided is that from the 1NF till 3NF,you have followed/explained the same example,you have explained it layman’s terms and using cell#,row# etc.This is one of the best explanatory examples I have ever come across.Thanks a Lot!!Good Job!
Good Tutorial. Clearly explained the three normal forms. Now even if I want, I cannot forget it. Good Job!
it is dam good and you explained every step in the easiest way thank you for the great healp, its realy best
Very good article.Was really very helpful.
nice article for beginners, really good
Very well explained! Helped a lot to clear the basic concepts of database normalization
Thanks, by far the best explanation or normalization I’ve ever seen.
thank you Fred for one of the best tutorials i have ever read.
i read many of your other posts as well, including the cat stuff.
i especially like the performance monitoring and the o_direct and dt utility.
thanks again, it’s the kindness and knowledge of persons like yourself that helps me stay employed. please keep it up, ( i also have cats to feed, (kids too)):]
i need employee management system softwares tutorial
in my mail id babi_sharma12@yahoo.com
hi
i wanted to know about human resource management system about banking
in programming idea
The idea is awesome and it is easy to understand the concept of normalisation.Really i am inspired by the article.It removed all my doubts related to Normalisation.
I am a database developer.
This tutorial gives a outstanding explanation of the concept of normalization. The steps and approach illustrated here can help normalize realtime databases.
Great work Man!!!!
Stunning. Outstanding. Perfect!
Concur with your reviewers – You are spot on Fred and everything is soooooo clear i can’t beleive how i stumbled on your site after going through so many articles on Normalization that were “Greek” (no pun intended for the wonderful people of Greece)to me.
God bless! you even have humour! i hope you are a teacher. I have never given a review online, but you surely deserve it and i could not wait to finish the article to post one.
There are no words to express my abundant thankfulness to you. My search has ended I can say.
this was really very useful article. but i think theres no need of having 2 phases for the decomposition of the second normal form. it can be done in one phase i guess. thanks.
A very good article.
But you miss one minor detail.
The price in the item entity may change over time.
I consider it acceptable to keep the item price in the order detail, or have a price change many side relation to the item.
The price exists independently at the time the order is placed or fulfilled, depending on business rule.
The example and explanation are really helpful. Thanks for posting this article.
Thanks
This is very good material for normalization. Thanks to publisher
Awesome description !!!!
Normalization is explained very beautifully !!!!
Simply superb . (No charge for awesomeness
)
hai dear,
I’am really thankfull to you this is a nice article to go through for the one who want to know clear description about NF’s. nice work dude.
Even though there are plenty of praise posted already, I still have to add mine: excellent tutorial!
I’d like to see similar tutorial on explanations beyond 3NF in the future.
Thanks!
Gud work…
Thxs for the Post
ya its realy nice..great work..i am totally blank in normalaization now i got a clear idea oon normalization…nice
The best Example I have ever seen. I dont know who has prepared this but hats off to you !!!!!!!! you have a very good idea on this !!!! Keep it up Boss….
Understanding made very easy……………………….
3 normal forms are explained besutifullly……….
Thank you Fred
BEAUTIFULL!!. This is an example on how all the tutorials should be like. Excellent contents.
Wow thanks for the tutorial, I kinda understood the concept, but the terminology escaped me. Thanks!
Salute to the author, This article shows you can simply make understand others the Complex things in easy manner if you know your job.. Thank you so much for this…
Fred
For the first time someone explained exactly what a Tuple means. Otherwise all reputed writers either define it by some set notations and bla bla or they just call a row as a Tuple. Your article has been one of the best reading that I ever had and your style just suits you to be defined as a “Mentor” or a “Guru”. This is how a Guru is supposed to explain. You have pulled another life-long student for yourself. Thank you very much.
regards
ranjan
Apart from my business, I teach advanced database design to guys who reside at Her Majesty’s Pleasure and are rehabilitating, and I have found that this protocol is excellent. Really good, and rare to find such a clear description of the process required to build a relational database.
David,
I am more than happy to assist with Her Majesty’s pleasure in any way I can!
Thanks for the kind remarks.
I´de like to see some problems solved here… if price or description of itemid changes over the time, and we go back to see/edit invoice details, we get the new values, not the ones that made up de invoice first time. Even for beginners this is not a system we should use because invoice history is forgotten. But anyway this is a great tutorial for NF.
Excellent, Normalization is explained very beautifully !!!!
Simply superb explanation…. hats off to u..
Thanks!! Finally all my “huhs” about normalization have been answered. After reading the article I said God bless you for putting it out there. Keep up the good work.
so much simplified explanation !!
Its really cool !!
Thanks a lot !!
Off course an excellent tutorial. But I expect a little bit more clear explanation on 1st normal form. IT does not seems to be sufficient.
One more thing. May you kindly contribute your tutorial over higher levels of normalization? It would really be helpful. Also, some more examples will surely help the learners.
You light my road to do database normalization. Thank you so much for the clearly explanation how to do it. Helpful!!!
Databases have always been a weakness for me as a developer. I can sort-of-intuitively get things in to 3NF but I could never explain why. Now I can, thank you! Could please now do 4-6 Normal Forms as well?
Hi I can say your guideline it was quite excellent cause it was quite clear in term of explanation I can say. It was quite completely awsome technique. Thanks for a good article. Best.
Well summarized, Straight to the point and very helpful indeed!
An infant could understand normalizations reading this material.
Thanks. Your the best!
nice work
What my professor couldn’t do in 2 weeks of lecture, was accomplished with this tutorial.
I finally “FULLY” understand how the 3 normal forms work, and are carried out.
Well done, easy to follow and appreciated greatly!
So nice,This is very cruicial,I am so impressed with this article.
very nice tutorial.
it was great… thanks..
Hi,
Thanks for making the explanation of normalization so clear and simple.I loved every bit of explanation.Your efforts is greatly admired.
Really very well explained..
Awesome work!
Thanks, this was really help, keep it up…
Its really good.step by step explaination is very nice to understand clearly..
Thanks.
crisp , to the point , amazing clarity . Simply superb
.
Very clear presentation… Great work…
OMG…. Despite reading texts by big names (Korth, Chen etc) i couldn’t clear it out that what was mormalisation. But reading your text has cleared every concept of mine regarding normal forms.
It goes by the saying the most famous books by the most famous authors are generally the most complex.
Hi,
Its a really great article. Every line provides valuable inputs to the readers. Excellent narration.
Thanks,
Hariprasad R
The example taken and basics of normalization is very clear.Thanks for the info.
With SAP BI, the rules about normal forms are often ignored during ETL, so, the concepts receded in my mind as I use(d) the model provided by SAP. Reading this made the concepts fresh again, and provided ‘handles’ better than I had before. Thx.
This is definetly an excellent way of putting the Normalization concepts in a Novice Mind. Well Done Author !
this tutorial helped me alot,its simply outstanding!!!!
Very well framed tutorial.
Hope to see another tutorial for other normal forms too.
Great work!!!!!
Thank you very much for your explanation in your tutorial, with the examples you have given clarity to this complex subject.