2016.04.09 use PowerDesigner to create a conceptual model of the database and turn it into a physical model

2016-04-09 21:10:24 The original is protected by copyright, and is strictly forbidden to reprint.

Please do not use for commercial purposes, support the genuine, we are doing software, know how to develop a set of software is not easy AH!

Today I saw a very interesting and useful Assistant development tool that is easy to use and makes it easy to create a database and a physical model of designing a database.

Let the original logic high, abstract bad design of the relationship between the data, become visualized. Allowing developers to quickly create larger, more complex relational databases is easier to develop and easier to understand. Nonsense will not be said more. Just give us a little dry goods and take the road.!!!!!

One---Installation

First of all, the installation is probably no one will not install the application software, it is not more introduction to install, as long as the installation of the path to the NEXT line.

Ii.---Building a conceptual model

Go to the main interface and then create a new mode, creating a CONCEPTU Data Model

L

Click OK to create the success that's right

Use the toolbar on the right to drag and drop controls. If the entity control is a data table

Click on the Data Type column to select the datatype

Setting the primary key is in P's position, which is actually too small to display is actually

Establishing relationships between tables this is associated with relationship.

It's like this after the connection.

By double-clicking the dashed line you can design relationships such as: one-to-one, one-to-many, many-to-many basis relationships

Finally, the following types of database relationships are designed:

To this conceptual model to complete this!!!

Three---Build a physical model

In case you want to save the concept model in the present.

Then just click into tools and click

Choose the type of database you want, and I'm using MySQL because SQL Server is too big for personal development

Click Apply, and make sure that the physical model is created successfully!!! Look at the work area one more. and the table is converted to the MySQL data type.

The physical model was created successfully!!!!

　　---Generate SQL statements

Press Ctrl+g to quickly build and select Save area.

Land---final product generation

Summary and statement of Qi---

There may be compatibility issues, depending on the system of the machine, it is possible to test the WIN7 in person and the software version is 16.5.

This is an introduction to the use of development tools that can reduce the possibility of errors when we build database relationships. Greatly facilitates our development, with the early discussion of the project understanding. This article is the handwriting of Mr. Chi Hua, protected by copyright, strictly prohibited reprint.

2016.04.09 use PowerDesigner to create a conceptual model of the database and turn it into a physical model