Database design method

You create a database in 4 consecutive steps:
Scope Logical Design Technical Optimisation Implementation

1. Scope

2. Logical Design

3. Technical Optimisation

4. Implementation


  • Use sticky pads. That's a very convenient way of working. You can concentrate on the design, instead of the tool.
  • Database design is quite tricky. Pererably you design with a team of 2 or 3 men.
  • Allow discussions to run freely. Take sound decisions.
  • Iterate. It's ok to be right the 3rd time. Version 3 can only come into existence after version 1 and 2. So, version 1 & 2 are not wrong, but neccessary intermediate steps.