Category Archives: normalization

A Brief Introduction to Data Normalization

Posted on April 11, 2015 by craig@craigsmullins.com

Normalization is a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent. A table is … Continue reading →

Posted in data modeling, database design, normalization | 5 Comments

The 7 Types of Database Design Reviews

Posted on December 12, 2013 by craig@craigsmullins.com

A little more than two years ago I wrote about The Importance of Database Design Reviews here on this blog. The general idea of that post is that reviewing the scope and content of a database implementation before it moves … Continue reading →

Posted in database design, indexing, normalization, performance, SQL | 19 Comments

A Question on Logical Modeling and Normalization

Posted on May 31, 2013 by craig@craigsmullins.com

I received the following question and thought I’d answer it on the blog: Question: I work in a data-modeling environment with the responsibility of logically modeling (LM) data for mainframe and server databases. LM for the OLTP systems are done … Continue reading →

Posted in data modeling, normalization | 8 Comments