| « First 3 Rules of Data Normalization for Newbies - Part 1 | What working with almost no sleep can do ... » |
First 3 Rules of Data Normalization for Newbies - Introduction
![[mail]](img/envelope.gif){kind=small}
| 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:
- First Normal Form (1NF): All attributes are not repeated or must be single-valued
- Second Normal Form (2NF): An attribute must depend upon its entities entire UID
- 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.
XML Feeds