MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It is a free and open source database designing application that's attractive, advanced, well-designed, reliable and light on system resources.
Here are some screenshots to illustrate the features and user interface of this application: