Database design using PowerDesigner [reprint]

Original website: http://www.cnblogs.com/Ferry/archive/2011/01/12/1934126.html

Just recently used in this aspect of things, see this blog, feel very good, so reproduced over collection. The following is the body content:

Here is a preliminary design with PowerDesigner, which may be modified later.

1. Start PowerDesigner New physical data model

2. Tool bar

3. New Table Model

4, add the first table, you can double-click the table or the right-click menu to open the following window

Don't forget to select the owner of dbo and switch to the Columns tab

Upon completion, the form of the table was of this virtue.

Follow this procedure to add additional tables in turn

6. Add Table relationship, check Toolbox Relationship tool, drag from table to Main table, double click relationship appears right window

7. Configuring Database Connections

8. Create a database and generate a table in the database, where I first created the database in SQL Server Management Studio and then

Because the database has been generated and coexist in the DBO schema, so the hook is removed, leaving the default is OK, here to note, if the database already exists in the table, and want to retain data, you have to choose the "options" here, the back of the "Selection" is also

Immediately after "Run", the resulting table can be seen in the database.

Database design using PowerDesigner [reprint]