DATABA NORMALIZATION

DATABA NORMALIZATION

1. Database normalization is to designate and apply a set of rules to relations obtained after step model entity - relationship to the relationsl model.

   • Dependencias
     • Functional dependence
     • Reflective functional dependence
     • Reflective functional dependence
     • Transitive functional dependency
   • Deducted properties
     • Union
     • Descomposition
     • Keys
   • Code Rules
     • Rule No. 1 - The Rule information
     • Rule No. 2 - The access guaranteed access rule
     • Rule No. 3 - Systematic treatment of null values
     • Regla No. 4 - La regla de la descripción de la base de datos
     • Regla No. 5 - La regla del sub - lenguaje Integral
     • Rule No. 6 - The rule updating views
     • Rule No. 7 - The rule to insert and to update
     • Rule No. 8 - The rule of physical independence
     • Rule No. 9 - The rule of logical independence
     • Rule No. 10 - The rule of independence of integrity
     • Rule No. 11 - Distribution Rule
     • Rule No. 12 - Rule of non - subversion