Diagram Overview

Top Previous Next

Database Designer for MySQL allows you to create physical Entity Relationship Diagram, that will represent object in your MySQL database.

A diagram represents the tables of your database and the relationships between them. At its core, a data diagram depicts the underlying structure of your database. It allows you to specify the data type to be used by each column in the table, and determine how tables will be stored in the database.

A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations. The data diagram can also serve as an invaluable communications tool for both internal and external constituents.

Moreover, the diagram you define does not only depict the underlying database structure, but with functionality of Database Designer for MySQL allows you to generate appropriate databases and even bring existing databases to the state of your diagram.

In the following picture you can see four tables: Customers, Cities, Orders, Cars, their columns and the references between them. Also you may see that there are indexes defined for table "Customers".

Click to enlarge

You can change the appearance of the diagram, control the number of the object attributes, which are displayed in the diagram, define the diagram grid displaying and behavior and so on in Diagram Display Preferences dialog.

See also:
Diagram: Notation | Creating a New Diagram | Diagram Display Preferences