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

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.

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.