which tool( visual, open source ) do you used to design database ? thanks .
Not very high-tech, but usually I start with a large sheet of graph paper, a pencil, and an eraser. 🙂
Mysql workbench is pretty useful. Only on windows, but linux version is on the way.