DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It is a free and open source database designing application that's well-designed, efficient, straightforward and user friendly.
Here are some screenshots to illustrate the features and user interface of this application: