New Book Explains Database Normalization Techniques

Share Article

Understanding and mastering database normalization techniques is essential in order to achieve a high performance system database design. If the initial design doesn't conform to (at least) the Third Normal Form (3NF), chances are high that it will be hard to achieve the performance needed for a successful application.

Many "experts" will say that if you do database normalization up to (and including) the Third Normal Form, you're well off. The Database Normalization eBook shows that this a far too easy approach, and it is richly documented with graphical Entity Relationship and Server Diagram examples.

The Database Normalization eBook will walk through all the 5 Normal Forms in database normalization normally used to analyze data models in the making. It starts with formal definitions, and then explores and explains them in plain language. 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). The Database Normalization eBook uses a consistent theme of accounts, departments, projects and transactions throughout, so it can be easy to review the consequences as we move from First Normal Form through all the accepted Normal Forms.

Pros and cons of denormalization with the aim of improving performance are also discussed, and which consequences denormalization may have on your database. The Database Normalization eBook is illustrated with more than 20 entity relationship diagrams, as well as database (server) models, and SELECT statements that use the model.

The Database Normalization eBook includes complete DDL (Data Definition Language) scripts for creating the tables, indexes and constraints from the example database model in the eBook, for both Oracle and MS SQL Server. This will give a view of the components that need to be created in order to build a fully normalized sample database.

For more information, please visit http://tinyurl.com/4ypy8

###

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Robyn Sharpe