Posts

Showing posts from January, 2013

Normalisation Definitions

Summary of Normalization 1st Normal form removes repitition by creating one-to-many relationships 2nd Normal form not creates one-to-many relationships but many-to-one relationships, thus effectively seperating static from dynamic information. 2nd Normal form removes items from tables independent of  primary key. 3rd Normal form is used to resolve many-to-many relationships into unique values 3rd NF allows uniqueness of information by creation of additional many-to-many join resolution tables