Documentation Home
MySQL Workbench Manual
Related Documentation Download this Manual
PDF (US Ltr) - 17.0Mb
PDF (A4) - 17.0Mb

MySQL Workbench Manual  /  Database Design and Modeling

Chapter 9 Database Design and Modeling

Modeling simplifies database design and maintenance by enabling you, the data architect, to visualize requirements and resolve design issues. Model-driven database design is an efficient methodology for creating valid and well-performing databases, while providing the flexibility to respond to evolving data requirements. Models are used to build EER diagrams and physical MySQL databases.

MySQL Workbench provides extensive capabilities for creating and manipulating database models, including these:

  • Create and manipulate a model graphically.

  • Reverse engineer a live database to a model.

  • Forward engineer a model to a script or live database.

  • Create and edit tables and insert data.

This is not an exhaustive list. The following sections describe these and additional data-modeling capabilities.