Draw database ER diagrams using StarUml and generate SQL code using DDL

StarUML(SU) is a tool for creating UML class diagrams, generating class diagrams, and other types of Unified Modeling Language (UML) diagrams. StarUML is one of the open source projects that is fast growing, flexible and extensible.

StarUml download address

This article introduces the use of StarUml to draw ER diagrams in database design, and use the DDL plug-in in StarUml to generate SQL code.

Create an ER diagram model

Create entities and add attributes

Select relationships between entities (one-to-one, one-to-many, many-to-many)

Set the type, length, primary key, and so on of the property

Download the DDL plug-in

It was already installed

Use DDL to generate SQL code

Select the drawn ER diagram model