Category Archives: normalization

A Brief Introduction to Data Normalization

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

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 | 16 Comments

A Question on Logical Modeling and Normalization

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 | 7 Comments