Database design essentials

There are a lot of books on relational database design. Some of them are very mathematical. But for small applications, just some rules must be known.

  1. All tables are at least in the third normal form
  2. All PKs are integers (and then all FKs)
  3. Null values are not allowed
  4. Applications have access to views (not to tables)