Understanding Normal Forms

I think I have a relatively good understanding of the basic applications of the Normals Forms, and I am fairly comfortable bringing most database structures to 3NF and I see the benefits thereof.

But my understanding is fairly shallow and comes from a hodge podge of different sources that all explain the application without really providing the theory behind it. I am also faced with trying to explain it to some other more junior SQL developers and I am not certain I can do that as well as I would like.

So, what are some good references for really understanding the Normal Forms? I am looking both for things to help me gain a deep understanding of them, and to help introduce newer developers to the basics.

more ▼

asked Jun 29, 2010 at 04:09 PM in Default

avatar image

15.6k 22 57 38

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Check out this books I had from school: Database Systems:A Practical Approach to Design, Implementation and Management and Database System Implementation. Its been a while since I opened them but I remember having a good time reading them. These books are vendor neutral and more academic.

more ▼

answered Jun 30, 2010 at 06:02 AM

avatar image

4.9k 33 39 43

I used that first book when I went to Uni, and I've still got it...somewhere. It is a good book

Jun 30, 2010 at 05:05 PM Daniel Ross
(comments are locked)
10|1200 characters needed characters left

I still haven't replaced a rather old reference book, Handbook of Relational Database Design by Fleming & von Halle. It's one of the best descriptions of normalization I've found, despite it's age. Plus, you can get a practically new copy for a buck, so it's hard to knock the price.

more ▼

answered Jun 30, 2010 at 05:20 AM

avatar image

Grant Fritchey ♦♦
137k 20 47 81

(comments are locked)
10|1200 characters needed characters left

I think wikipedia is a great source for many different things. http://en.wikipedia.org/wiki/Database_normalization#Normal_forms

Each attribute must be a fact about the key, the whole key, and nothing but the key. - Wiorkowski and Kull

(normalize until it doesn't work, denomarlize until it works again)

more ▼

answered Jun 30, 2010 at 12:08 AM

avatar image

Håkan Winther
16.6k 38 46 58

I thought it was "normalise until it hurts, denormalise until it works."

Jun 30, 2010 at 12:19 AM ThomasRushton ♦♦

Either works, both are wrong, sort of.

Jun 30, 2010 at 05:20 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 29, 2010 at 04:09 PM

Seen: 1959 times

Last Updated: Jun 29, 2010 at 04:09 PM

Copyright 2018 Redgate Software. Privacy Policy