by Marius Gheorghe
27. August 2009 16:13
So, first of all, how would a GOOD documentation would help us ? What would we gain from it ? Well :
- new people could be brought to speed very easely. No need to chaperon them while they understand the system, no need for different programmers to each explain to the new guy a small piece of the system.
- easy maintainance.
- remove dependency from the people who designed/understand the system.
Here's my take on what and how this should be done.
- document the initial requirements of the project.
- the "core" of a business system is the database schema . That's the most important thing which should be documented. SqlDoc is a great tool for this. If you can't afford it then use a simple text editor. But DO document the schema of the database.
- document all the business procedures and requirements of the system. Some businesses have some pretty wacky procedures and requirements (if you worked with a financial system for instance, you probably already know that). Gather all these procedures and requirements and document them. Make sure the documentation is "tied" to the documentation of the database schema.
- create a entity relationship diagram.
- the most important advice of all : be explicit. Do not use shortcuts in the name of the database columns and do explain the specific business terms.