One of the key steps for
the modeling data is to do the survey requirements. Identifying the
environment and extract the correct information, separating the
parties and the relevant data that formed the tables in the
database.
A well-structured database is a major step forward that will avoid
future headaches.
I usually use to model a database program Dbdesigner I think the
simple and practical.
I think very important to have everything documented, especially if
you want to do a commercial software, because that will help you
even when you prepare a budget, beyond what has the documentation
system is not easily found, the staff usually does not properly
documented the structure and development of programs, is more like
programming.
