如何在Workbench中将增强型实体关系（EER）图转换为UML类图

Alright, let's break down exactly how to turn your EER diagram into a UML class diagram using MySQL Workbench— I’ve gone through this process dozens of times, so it’s pretty straightforward once you know the ins and outs.

• Fire up MySQL Workbench and open your .mwb EER diagram file (if you don’t have it saved yet, make sure to save your current EER project first).
• Switch to the Modeling tab at the top— this is where you’ll see your full EER diagram layout.

Workbench has a native tool to convert EER models directly to UML class diagrams, no extra plugins needed:

• Click the top Model menu (if you don’t see the option right away, check the Diagrams submenu under Model— some versions tuck it there).
• Select Create UML Class Diagram from the dropdown.
• A popup will let you choose which entities to include (default is all, but you can deselect any you don’t need). Hit OK, and Workbench will spin up a new tab with your auto-generated UML class diagram.

Auto-conversion gets you 90% there, but you’ll want to adjust a few things to match UML standards:

• Entities → Classes: EER entities map directly to UML classes, but double-check:
  • Mark primary key properties with a * (or use + to denote public access, since PKs are usually publicly accessible in class designs).
  • Verify association multiplicities (the 1 or * labels on relationship lines)— Workbench pulls these from EER foreign keys, but it’s easy to miss a mismatch.
• Inheritance: EER generalization (parent-child entity relationships) translates directly to UML’s hollow arrow generalization relationship— make sure the arrow points from child to parent class, which Workbench should handle automatically, but it never hurts to confirm.
• Data Types: Workbench carries over database-specific types like INT or VARCHAR. If you need standard UML types, swap them for Integer or String; if you’re keeping it database-aligned, leave them as-is.
• Constraints: Non-null, unique, or other EER constraints can be added as notes (use the text tool) or appended to property names, e.g., email: String [unique, not null].

• To save it within Workbench, go to File → Save Diagram As... and store it as part of your existing .mwb file or a new one.
• For image exports (PNG, JPG, etc.), use File → Export → Export Diagram to Image....
• If you need a standard UML format to use in other tools (like StarUML or Enterprise Architect), export as XMI via File → Export → Export Model to XMI....

内容的提问来源于stack exchange，提问作者Megumin