Elements of the Ideal Field

  Previous section   Next section
  • It represents a distinct characteristic of the subject of the table.

  • It contains only a single value.

  • It cannot be deconstructed into smaller components.

  • It does not contain a calculated or concatenated value.

  • It is unique within the entire database structure.

  • It retains the majority of its characteristics when it appears in more than one table.


Part II: The Design Process