To present the solution design, Entity-Relationship Diagram (ERD) is still one of the common diagram to present data and its relationship. But it is the nightmary if draw it as it is complicated and human error.

For such cases, there are many database management tools can generate ERD. In MySQL workbench, it also can generate with plugin. Details as below.

Steps to generate ERD

1. Open Reverse Engineer wizard.
   In MySQL workbench, Select Database > Reverse Engineer...
   
2. Connect target database.
   In Reverse Engineer wizard, input database information and click Next.
   
3. Collect database details.
   It will load for while to get database server. Click Next when load completed.
   
4. Select target database.
   Select database which would like to generate ERD, and then click Next.
   
5. Start reverse engineering.
   It will show page on notify start scan database schema, click Next to continue.
   
6. Select tables to be render.
   It will show scanned tables in database. Select tables to be show. By default, all tables selected. After remove tables if needed, then click Execute.
   
7. Verify result.
   ERD will generate, check column and data type align with database or not.