Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted May 9, 2016

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

By Rob Gravelle

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:



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.

The Action History List
The Action History List


Considering the complexities involved in keeping models and database structures synchronized it only makes sense to use a specialized tool to facilitate the propagation of changes from one to the other. The tool that we employed here today - Navicat Data Modeler - is available for the Windows, Mac OSX, and Linux platforms from the Navicat store   An individual commercial license is $249.00 USD while a Non-Commercial Edition license may be purchased for $199.00 USD. 

See all articles by Rob Gravelle

MySQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM