Data Normalization

on

  Data Normalization 

    




Process of arranging data to reduce data redundancy and ensure data integrity. 
Data redundancy: Storage of duplicate data within the same database
Duplication: Creation of exact copies of data which may not result in redundancy depending on where that copies are stored. 
  1. 1NF: First Normal Form
    • Each attribute in table must contain atomic value (i.e. value cannot be further subdivided)
    • No repeating groups (i.e. set of related columns within the table that contain multiple values that belongs to same group or category. 
  2.  2NF: Second Normal Form
    • A table must be in 1NF and every non-key attribute must be fully functionally dependent on the primary key. (i.e. Partial dependency must be removed).
  3.  3NF: Third Normal Form
    • A table must be in 2NF and every non-key attribute must be non-transitively dependent on primary key(i.e. transitive dependency must be removed).

Comments

Post a Comment