|
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.
(comments are locked)
|
|
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. I used that first book when I went to Uni, and I've still got it...somewhere. It is a good book
Jun 30 '10 at 05:05 PM
Daniel Ross
(comments are locked)
|
|
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.
(comments are locked)
|
|
I think wikipedia is a great source for many different things. http://en.wikipedia.org/wiki/Database_normalization#Normal_forms
(normalize until it doesn't work, denomarlize until it works again) I thought it was "normalise until it hurts, denormalise until it works."
Jun 30 '10 at 12:19 AM
ThomasRushton ♦
Either works, both are wrong, sort of.
Jun 30 '10 at 05:20 AM
Grant Fritchey ♦♦
(comments are locked)
|
