Create and Modify EER diagrams with MySQL Workbench
Reverse Engineer a Database to Extract ERD
Workbench adds a graphical user interface to MySQL. WHile the interface seems relatively simple it is actually quite powerful allowing users to accomplish complex tasks with a few clicks. One of the most powerful tools in Workbench allows users to graphically create data models and implement them. Even more powerful, is the ability to extract data models out of existing databases.
This reverse enineering of a database allows you to recreate any database and or modify and reimplement it with a few keystrokes. This tutorial covers:
- Generate and EER (Enhanced Entity Relationship) Diagram with MySQL Workbench.
- Export the diagram as a graphic
- Use the diagram and resulting model to create and/or modify databases.
- Push design modifications made graphically through to an existing database
- Reverse Engineer Database
- Forward Engineer Database
- Synchronize Database
You may also be interested in:
Creating Databases & Loading Data
How to add foreign keys, create relationships
Basic MySQL Queries
INNER and OUTER JOINS
Using MySQL Text Functions
Statistics with MySQL