Furthermore, you will find that writing good DML-statements (SELECT, UPDATE, INSERT or DELETE) is difficult, and sometimes actually impossible, without using a lot of procedural coding (PL/SQL in Oracle, VB/C# in Microsoft products).
Many "experts" will tell you that if you do database normalization up to (and including) the Third Normal Form, you’re well off. The Database Normalization eBook shows you that this a far too easy approach, and it is richly documented with graphical Entity Relationship and Server Diagram examples.
The mission of this 50-page eBook is not to deliver academic definitions of the normal forms, but to communicate the author’s practical experience in data modeling using database normalization techniques, built on nearly 30 years of business experience with data modeling for government, industrial, communications and other large relational database customers.
The Database Normalization eBook also contains separate chapters on Boyce/Codd Normal Form (BCNF), and Domain Key Normal Form (DKNF).
"Your eBook is now mandatory reading for my project members." Sabrina, Project Manager, Germany
"I’m myself (since 1996) in the data modeling business (OLTP and OLAP, with accent on OLAP for the past 5 year). I own and have read about 30 – 40 books on this topic (practically most of the available and out of print books) and I’m still impressed by your website and ebooks. I like a lot of things about the keynotes and ebooks, what I like most is the balance you have managed to keep between a dry subject / theory and a clear "down-to-earth" treatment of the subject, without sacrificing any of the important aspects. The examples in the normalisation ebook are also very good." Georg Breazu, Senior Systems Consultant, Germany
"I’ve seen good, bad and butt ugly database design books. The database normalisation eBook is in the category of good. It is a concise guide, based on scientific principles and common sense." Philip, Systems Analyst, United Kingdom
"I am about to start teaching Normalization to my students, and was wondering whether anyone can recommend an idiot’s guide to BCNF for me! I am fine up to 3rd NF, then confusion sets in!… I would really like a simple explanation as any reference to BCNF which I have found so far on the Net is coughed in technical terms rather than words of less than two syllables…"
I know all about it: I have been teaching database design through my job for many years. It was actually what motivated me to write this eBook: Trying to explain a complicated theme in an understandable and engaging manner.
"I am about to start teaching Normalization to my students, and was wondering whether anyone can recommend an idiot’s guide to BCNF for me! I am fine up to 3rd NF, then confusion sets in!… I would really like a simple explanation as any reference to BCNF which I have found so far on the Net is coughed in technical terms rather than words of less than two syllables…"
Robert told me that he’s using the graphical illustrations (Entity Relationship and Server Model diagrams) from my eBook to create a concistent theme through all the five Normal Forms for his students. Robert is also using my DDL scripts to actually create an example database for his students. You can too:
Some things you won’t even learn properly: If your teacher isn’t able to help you, who can? Take a look at this: It is a forum post from a teacher somewhere in Cyberspace: "I am about to start teaching Normalization to my students, and was wondering whether anyone can recommend an idiot’s guide to BCNF for me! I am fine up to 3rd NF, then confusion sets in!…I would really like a simple explanation as any reference to BCNF which I have found so far on the Net is coughed in technical terms rather than words of less than two syllables…" Imagine if your future degrees depend on this teacher… I will let you in on a little secret: For 25 years, I have been responsible for hiring consultants for various companies. I love to hire freshly educated people; Very often, they bring enthusiasm, guts and new ideas with them. However, I always put them through subtle testing. Understanding database normalization techniques is high on my priority list… Take control of your own future, and get the essentials of database normalization explained in an easy and engaging style. Use your saved time for other things to do and study.
"I’ve seen good, bad and butt ugly database design books. The database normalisation eBook is in the category of good. It is a concise guide, based on scientific principles and common sense." Philip, Systems Analyst, United Kingdom
I own and have read about 30 – 40 books on this topic (practically most of the available and out of print books) and I’m still impressed by your website and ebooks. I like a lot of things about the keynotes and ebooks, what I like most is the balance you have managed to keep between a dry subject / theory and a clear "down-to-earth" treatment of the subject, without sacrificing any of the important aspects.
The examples in the normalisation ebook are also very good." Georg Breazu, Senior Systems Consultant, Germany
I own and have read about 30 – 40 books on this topic (practically most of the available and out of print books) and I’m still impressed by your website and ebooks. I like a lot of things about the keynotes and ebooks, what I like most is the balance you have managed to keep between a dry subject / theory and a clear "down-to-earth" treatment of the subject, without sacrificing any of the important aspects.
The examples in the normalisation ebook are also very good." Georg Breazu, Senior Systems Consultant, Germany
"Your eBook is now mandatory reading for my project members." Sabrina, Project Manager, Germany
If you are serious about understanding how databases are designed for maximum performance and minimum (no) redundancy…
Database Normalization Techniques - Essentials
No comments:
Post a Comment