Rules for Normalization

• Basic #1 Rule
  • The attribute values in a relational table should be functionally dependent (FD) on the primary key value.
  • In any table, a field A is said to be functionally dependent on field B if, regardless of any insertions or deletions, the value of B determines the value of A (in other words only one value of A occurs with a particular value of B)

Previous slide

Next slide

Back to first slide

View graphic version