First page Back Continue Last page Image

Normalization

  • Customer
  • Key
  • Field
  • Type
  • PK
  • CNumb
  • CName
  • Cad_Hn
  • Cad_Cty
  • Cad_St
  • Cad_Zip
  • Address
  • Key
  • Field
  • Type
  • PK
  • ANumb
  • FK
  • CNumb
  • Cad_Hn
  • Cad_Cty
  • Cad_St
  • Cad_Zip

In true full normalization there is 1 place and only 1 place for each element of data in a database (i.e. No data Duplication)

There are other elements to Normalization but this is the only one we will focus on in this class (But if you are in my AD-350 class you will learn the others)

Full Normalization can be costly and complex, hence not all databases will be fully normalized