« First 3 Rules of Data Normalization for Newbies - Part 1What working with almost no sleep can do ... »

First 3 Rules of Data Normalization for Newbies - Introduction

12/18/04 | by Clarise | Categories: Modeling

The work of Dr. Codd as published in A Relational Model of Data for Large Shared Data Bank by E.F. Codd provides the detailed and comprehensive explanation of Relational Model and Normalization.

I just want my blog to be short and sweet each day. So, over the next 3 days, I shall blog on a normalization rule. I learn by example so I shall discuss the rules through examples.

Normalization helps eliminate the problems of redundancy in database design. It reinforces referential integrity in the database and provides a way to index. A highly normalized design may need a large number of joins. Hence, there is a need to carefully review the degree of normalization in a database design. One must consider the database’s intended use.

The First 3 Rules of Normalization are:

  1. First Normal Form (1NF): All attributes are not repeated or must be single-valued
  2. Second Normal Form (2NF): An attribute must depend upon its entities entire UID
  3. Third Normal Form (3NF): No non-UID attribute can be dependent upon another non-UID attribute

Part 1 of my blog will be about 1NF.

1 feedback »

1 comment

Comment from: Navjot Singh
Navjot Singh

Can you tell from where I can get the paper of Dr. Codd for free. The link you gave contains the incomplete paper. I want the complete paper. I searched for it but could not find it.

08/16/05 @ 23:54
May 2020
Mon Tue Wed Thu Fri Sat Sun
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
 << <   > >>
This blog contains thoughts that range from non-technical to technical. Its name is derived from "Yakity Blah Blah" a column I once had that discussed a cornucopia of ideas. Who am I? I'm Clarise Z. Doval Santos, providing Project Management and Technical Leadership for data management and analytic, data science, IoT and sensor analytics ecosystems 37.652951177164 -122.490877706959


  XML Feeds

Blog software