Tuesday, 2 August 2016

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

Creating a Physical Model


The Model Conversion command can also be employed to create a Physical Model from the Logical one.
  • On the Convert to New Model dialog, select MySQL 5.6 as the target database.

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
The Completed Sales Star Schema Physical Model

If you right-click a table and choose Design Table... from the popup menu, you’ll notice that the Design Table dialog contains information that pertains to the specific database type and version that you selected on the Convert to New Model dialog.

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
The Design Table Dialog

Creating a Model from an Existing Database


Creating new diagrams from existing database structures is a process known as Reverse Engineering. Navicat Data Modeler supports the importing of MySQL, MariaDB, PostgreSQL, Oracle, SQLite, SQL Server tables/views, as well as from ODBC data sources. If the model is logical or conceptual, all views will convert to entities after the import process.

This functionality is included as the Import from Database feature. To start the process, select Tools -> Import from Database from the main menu.

On the Import from Database dialog, you may choose to connect to a data source mentioned above via a new connection or by importing your connections from one of the Navicat Database Management tools:

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Import from Database

Once a connection is established, you can pick and choose the tables and views that you want to include in your model:

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Import from Database

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Conceptual Model

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Logical Model

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Logical Model – Close Up 

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Physical Model

Simplifying MySQL Database Design using a Graphical Data Modeling Tool - Page 3
Physical Model – Close Up