Create EER Diagram in MySQL Workbench
Enhanced entity-relationship (EER) diagrams are basically a more expansive version of ER diagrams.
EER models are helpful tools for designing databases with high-level models. With their enhanced features, you can plan databases more thoroughly by delving into the properties and constraints with greater precision.
Here’s the flow to made EER diagram in MySQL
- You need to make sure that you have database and tables on MySQL.
I will use Employees database which is have 5 tables ( departments, dept_emp, dept_manager, employees, salaries, titles ).
2. Click Database then Reverse Engineer
3. Click Dropdown from Stored Connection then choose your MySQL Server in which database is present. Then click next.
4. Input your password to connect MySQL server. After the execution gets completed successfully (connection to DBMS), click next.
5. Select Schema that you want to include then next.
6. Input your password again. After the execution gets completed successfully (Retrieve Object from Selected Schemas), click next.
7. Select object to reverse engineer, here i’ll check list in table objects and view object then Execute.
8. After the Reverse Engineering Process gets completed successfully, click Next.
Now you can see the EER Diagram of the Database.
