5 Rules of Data Normalization - The Diigo Meta page

• 08 Dec 07
  

  DataModel.org

  sql normalization

• 15 Dec 06
  

  dinh cuong vu

  database Normalization

• 15 Nov 06
  

  Cynthia Bowen

  Rules of Data Normalization Page

  database guide

• 25 Oct 06
  

  Seth

  Rules for data normalization.

  programming

• 19 Oct 06
  

  Adam Thompson

  database tutorial howto

• 22 Aug 06
  

  onyx peridot

  database normalization

• 25 Jul 06
  

  Zhe sto

  database imported delicious programming tutorial

• 19 Mar 06
  

  database_design database howto reference tutorial relational_model rdbms

• 04 Feb 06
  

  Joshua Aresty

  database programming

• 14 Jul 05
  

  Scott Edwards

  SQL_DB

• 17 Mar 05
  

  pvav pvav

  prog.database

• 01 Mar 05
  

  David Chaves

  models

• 17 Nov 04
  

  Todd Zimmerman

  database reference

• 23 Oct 04
  

  owen walton

  geekery w/ normalized data

  tools data reference

• 20 Oct 04
  

  Kevin Painting

  Web

• 
• 19 Oct 04
  

  zerapat42

  database oracle delicious

• 

  timothyfrisby

  sql

• 

  nick n

  databases development

• 18 Oct 04
  

  Fogday Studios

  statistics

• 

  Jason Reis

  data dev

• 

  Wen Zhang

  Statistics

• 

  Sensei Garfi

  métode, métode.

  Technology

• 

  LeadingZero .

  Data Normalization

  fURL oldlinks

  • # Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. # Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table. # Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table. # Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. # Isolate Semantically Related Multiple Relationships - There may be practical constrains on information that justify separating logically related many-to-many relationships. # Optimal Normal Form - a model limited to only simple (elemental) facts, as expressed in ORM. # Domain-Key Normal Form - a model free from all modification anomalies.
  • # Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. # Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table. # Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table. # Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. # Isolate Semantically Related Multiple Relationships - There may be practical constrains on information that justify separating logically related many-to-many relationships. # Optimal Normal Form - a model limited to only simple (elemental) facts, as expressed in ORM. # Domain-Key Normal Form - a model free from all modification anomalies.
• 

  toeknee

  database

• 

  spigot

  database

• 

  Edward Speer

  database

• 26 Sep 04
  

  Rafael Robayna

  database development reference

• 21 Jun 04
  

  Miska Lahti

  database

• 10 May 04
  

  nikogunadi

  database

• 05 May 04
  

  Lambert Heller

  Technology

• 29 Apr 04
  

  Dan O'Neill

  database normalization rules

• 28 Apr 04
  

  Bjoern Stierand

  database

• 27 Apr 04
  

  torkar

  DataModels

• 26 Apr 04
  

  Jose Maese

  database

Page Comments

• 
  Seth on 2006-10-25
  Rules for data normalization.

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.