Checkpoints for good database design

There is no right way to design a database—each one is different.
  • Give each record in a table a unique identifier (primary key).
  • Put each group of associated data in a table of its own.
  • Cross-reference related information by using the primary key from one table as the
  • foreign key in other tables.
  • Store only one item of information in each field.
  • Stay DRY (don’t repeat yourself).