Model

• Maintain referential integrity

  • Avoid garbage data

• Model reflects structure of the task

• Consider using columns

  • Default values
  • Columns expected to be used for search should be NOT NULL
  • Large columns like BLOBs should be kept in separate tables

• Identify tasks suited for triggers and procedures

  • Db-server does it faster

Notes: