Create ER Diagram of a Database in MySQL Workbench

Tushar Soam
Jan 24, 2018 · 2 min read
  1. First make sure you have a Database and Tables created on the MySQL server.
Image for post
Image for post

Example :-

Database - bank.

Tables - account, branch, customer, loan, trandetails.

2. Click on Database -> Reverse Engineer.

Image for post
Image for post

3. Select your stored connection (for connecting to your MySQL Server in which database is present) from the dropdown. Then click Next.

Image for post
Image for post

4. After the execution gets completed successfully (connection to DBMS), click Next.

5. Select your Database from the MySQL Server for which you want to create the ER Diagram (in our case the database name is “bank”), then click Next.

Image for post
Image for post

6. After the retrieval gets completed successfully for the selected Database, click Next.

Image for post
Image for post

7. Select the Tables of the Database which you want to be visible on the ER Diagram (In this case I am importing all the tables of the DB), then click Execute>.

Image for post
Image for post

8. After the Reverse Engineering Process gets completed successfully, click Next.

Image for post
Image for post

9. Click Finish.

Image for post
Image for post

Now you can see the ER Diagram of the Database.

Image for post
Image for post

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store