How to create E-R diagram in mysql

Question

I am using MySQL. There are 28 tables in my database. I've tried to use MySQL Workbench to create E-R diagram. As there are 28 tables, everything is messed up in diagram using MySQL Workbench. Is there any way to create E-R Diagram which shows all relations properly between 28 tables??

Thanks

Bothnia

Answer 1

The only free app I've been able to find that generates decent graphics (not beautiful but quite clear) is SchemaSpy. It's a command line Java program that generates quite comprehensive HTML documentation for any DBMS.

Grain

Thanks.I've just downloaded schemaSpy_5.0.0 jar file. But I am not able to run it in my system..I am using windows 7. Why?? – Bothnia

Perhaps if you care to explain how exactly Windows 7 prevents you from running it... – Cuomo

Nothing is happening. Its not showing any message while double clicking on schemaSpy_5.0.0 jar file. – Bothnia

Probably because: 1.- It's a command line tool. 2.- You cannot run a Java application by double clicking the *.jar file. There's an example in the program's home page. – Cuomo

Answer 2

To Create ER Diagram in MySQL follow these steps:

1.First install MySQL Workbench in your computer

2. Click File->Import->Reverse Engineer MySQL Create Script.
3. Click Browse and select your SQL create script.
4. Make Sure "Place Imported Objects on a diagram" is checked.
5. Click Execute Button.
6. Click Model->Add Diagram.
7. Open Catalog Tree and select/drag your tables on your ERR diagram.

Shortening

Answer 3

Open the MySQL Workbench and then go to Database -> Reverse Engineer (in this wizard you have 7 steps to generate the ER Diagram)

1-Connection Options:

For Stored Connection :( Select local instance )

For Password: Click on the Store in Vault.. and then enter your password

Then click on the next.

2-Connect to DBMS:

Click on the next (In this step you do not need to do anything)

3-Select Schemas

Here, select your desire Schema in order to generate an ER Diagram

4-Retrieves Objects

Click on the next (In this step you do not need to do anything)

5-Select Objects

In this step, you can click on the Show Filter to exclude some table if you like

Here, I exclude the emailAddresses table in order not to show that in the ER Diagram

6-Reverses Engineers

Click on the next (In this step you do not need to do anything)

7-Results

Click on the finish to see the Diagram

Sublimity

Answer 4

ERWin is another good tool. Allowing you to generate erd from sql code and sql code from er diagrams. Its a Drag and Drop utility.

Militate

Answer 5

SQL yog is one of the best tool which generate ERD and represents the relationship between different tables. It is also drag and drop utility and provide complete access to your mysql database.

Riha