Designing a database using the PowerDesigner tool

access to the company will use this UML Tools Oh.

1 Create Design ModelPhysical Data:

Note Select the type of database: then click OK

2New FormTable:

3To set a field:Check the primary key

tick p ( primary key), m means non-empty, set directly click OK

4To create a foreign key:manually modifying foreign keys

Click the Reference button to select from the table, point to the main table;

But there is a bug FK Span style= "font-family: the song Body;" > I want to be in dept_id Add a foreign key on the. To manually change each time, double-click the line with arrows:

5 Save model file PDM

 

The project manager said: "You from svn above checkout > PDM

You can then view it through the PD tool. The relationship between the table and the table, and so on.

6generate SQL file

7 SQL Import database, create data table complete

Designing a database using the PowerDesigner tool