Elements of the Ideal Table

  Previous section   Next section
  • It represents a single subject, which can be an object or event.

  • It has a primary key.

  • It does not contain multipart or multivalued fields.

  • It does not contain calculated fields.

  • It does not contain unnecessary duplicate fields.

  • It contains only an absolute minimum amount of redundant data.


Part II: The Design Process