Thursday, 4 August 2016

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 5

Tips & Tricks

Auto Layout


The Auto Layout button - found on the main toolbar - automatically arranges objects on the canvas.  This is often faster and easier than trying to arrange every diagram component yourself.

Here is a Conceptual Diagram of a Travel Bookings before and after executing the Auto Layout command:

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 5
Before

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 5
After

For more control over the diagram’s appearance, Auto Layout format settings may be set from the Diagram -> Auto Layout with... command on the main menu.  Options include:
  • Auto Diagram Dimension
  • Choose the suitable diagram dimension automatically.
  • Auto Size Tables To Fit
  • Resize the table to fit its content automatically.
  • Quality
  • The quality of the auto layout output.
  • Object Distance
  • The distance between the objects in the diagram.

Undoing Operations


One of the many advantages of using a GUI Modelling tool is the ability to easily undo one or many operations.  In Navicat Data Modeler, actions are tracked and displayed in the Action History list.  Clicking any item in the list instantly reverts the diagram state to that snapshot.

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 5
The Action History List