Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use Power Designer, the introduction in the article is very detailed, has a certain reference value, interested friends must read!

First we need to create a test database. For simplicity, we only create a Student table and a Major table in this database. The table structure and relationship are shown below.

See how to quickly create this database with PowerDesigner.

1. Now to create a database using PowerDesigner, first run the program and go to the main interface:

2.File-New Model-Physical Data Model-Physical Diagram-Model name is set to test,DBMS property is set to Microsoft SQL Server 2005:

3. First create a table template with the table tool:

4. Double-click the table template and set the properties. We first set the Major table:

5. Set the table name, click the Columns tab, and set the field properties, as shown in the figure:

6. Because we want to set the MajorID field to grow automatically, to set its advanced properties, select the MajorID field, click the properties button, and check the Identity check box in the General panel:

7. After confirmation, we create a Student table with the field settings as shown in the figure:

8. Next, create a MajorID foreign key for Student, which can be easily done with PowerDesigner. Select the relationship setting tool, hold down the left key on the Student table, and drag to the Major table to add a MajorID foreign key to the Student table:

9. Haha, now that the test table has been set up, let's set up the database we want to generate. These tables will be created in the database. We right-click-Properties in the blank space of the design panel, and the property settings dialog box that pops up is as follows:

10 well, we have finished setting up the new database here, but it is still empty in SQL. How can we transplant the structure designed here to SQLServer 2005? Perform actions: Database-Generate Database, set the stored procedure export directory and file name, and click OK:

11. Go to your export directory and you can see the exported database creation stored procedure. Open SQL, execute it, and you will see that the database has been magically created:

twelve。 All right, the preparation of the database is done. In the next article, we will use this database combined with CodeSmith to generate code in batch automatically.

The source code generated in the above practice:

SQL.sql

/ *

/ * Database name: PD_test * /

/ * DBMS name: Microsoft SQL Server 2005 /

/ * Created on: 17:27:17 on Sunday, 2010-6-13 * /

/ *

Drop database PD_test

Go

/ *

/ * Database: PD_test * /

/ *

Create database PD_test

Go

Use PD_test

Go

/ *

/ * Table: Major * /

/ *

Create table Major (

MajorID int identity

Name nvarchar (20) not null

Remark nvarchar (Max) null

Constraint PK_MAJOR primary key (MajorID)

)

Go

/ *

/ * Table: Student * /

/ *

Create table Student (

StudentID nvarchar (20) not null

MajorID int null

Name nvarchar (20) not null

Sex bit not null

Age int null

Remark nvarchar (Max) null

Constraint PK_STUDENT primary key (StudentID)

)

Go

Alter table Student

Add constraint FK_STUDENT_REFERENCE_MAJOR foreign key (MajorID)

References Major (MajorID)

Go

The above is all the contents of this article "how to use Power Designer". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.