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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


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

Featured Database Articles

MySQL

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:

Before
Before

After
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.

The Action History List
The Action History List

Conclusion

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