« Solstice to EpiphanyFirst 3 Rules of Data Normalization for Newbies - Part 2 »

First 3 Rules of Data Normalization for Newbies - Part 3

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

This is the last of the series on the 3 Rules of Normalization for Newbies. If you have forgotten the first 2 rules, review the 2 previous blogs because inherent to the 3NF Rule is compliance with the first two.

The 3NF Rule states: "No non-UID can depend upon another non-UID attribute." This basically means an entity is in the Third Normal Form if it is in 2NF and every one of its attributes is NOT dependent on any other describing attribute.

Let us consider the following example:

Training_Score is dependent on Training_Date. To make this in 3NF, move Training_Score and Training_Date to the entity Training.

So, this concludes our series on the 3 First Normalization Rules. The complete picture of our simple example is:

1 feedback »
 

1 comment

Comment from: Bala Yugandar
Bala Yugandar

Brilliantly explained. I looked up many examples and none did it so well. Beautifully simplified!

08/06/07 @ 18:36
October 2019
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

Search

  XML Feeds

free blog software