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… Read more…