For creating logical or phisical data models is used special software. One is SQL Power Architect, delivered also as Community edition, free to use.
It is very useful and easy to use the tool. It allows you design any database data model phisical or logical and convert it in SQL script or concrete database in any database system like Oracle, MySQL, PostgreSQL, SQL Server. This softwareallows also transform ready database to the logical or phisical model. You can also transform the database from one database engine to another.
In this part we start with installation.
First go to the website of this project
The website similar to this below appears:
COMMUNITYtab. You see the link
Download. Click it.
From the list of different edition, choose this free by clicking on
Now you see the list of links for available OSs. Click the link
Download. I choose Windows system.
The window appears with the question if you want to save the installation file. Click Save file if you do.
The file with format .jar will be download.
This software required JVM. However the last edition is not enough. Now the 13 version is last, but SQL Power Architect requires 7 or 8 version of Java. therefor it is good to prepare this version Java before the installation of SQL Power Architect.
Now you can run The installator SQL power Architect. First you see Welcome window:
Next. In next step you see licence to accept, click the
I accept ...
Click on the button
Next. The default path to the installation will be seen.
Browse to change it. my is Desktop path with any folder I written. Of course, on my Desktop isn’t this folder, it will be creating.
Next. You see message window about creating new flder for installation files.
Click the button
OK. In next step you see progress of the installation:
If you see
Finished, click the button
At the end click the button
Now go to the folder contains installation software:
architect, and you will see Welcome window, you can close it:
For users prefer video, watch it on YouTube: