Re-Normalize on the Candidate Key


After at least one candidate key has been noted, every
attribute and relationship of the entity must be tested -

  • Does this property depend solely and completely
    on the candidate key?
  • If not, move the property (normalize it) to the entity where
    it depends solely and completely on the candidate key.



    Copyright © 1996 Applied Information Science International