How to design a SQL Server database with PowerDesigner

Tools:

Sybase PowerDesigner 12.5

Microsoft SQL Server 2005

The first step: outline Design

Open the PowerDesigner software and design the "Conceptual Data Model" (conceptual):

Figure 1

Design Table structure:

Figure 2

When designing properties (fields), three letters (M, P, D) represent:

M: Is null (√ indicates not allowed to null)

P: whether the primary key;

D: Whether it is displayed in the view of the software;

Step Two: Detailed design

Converting the table designed by the conceptual data model to the physical data Model (physical) is actually converted from "Profile design" to "detailed design", that is, the concrete implementation of the table.

Select "Tools"--> "Generate physical Data Model ...".

Figure 3

Then select SQL Server 2005 database management software:

Figure 4

By clicking on the "OK" button, a specific implementation of the tables, attributes, and relationships for the SQL Server 2005 database is generated.

Step three: Create a database manually in SQL Server 2005

For example, I manually created the database "Students" Sample in SQL Server 2005.

Step Fourth: Configure the user data source in the data source ODBC

For example: I add a data source for the database "Students" in the user data source.

Figure 5

Step Fifth: Automatically create a table structure in SQL Server 2005

First: Automatically create the appropriate SQL statements according to the physical data Model (physical):

Figure 6

Second: Execute the SQL statement file that it creates, and automatically create the datasheet structure to the SQL Server 2005 database:

Figure 7

After you complete the steps above, refresh the SQL Server 2005 data and you will see the related table structure that you created.

Of course, the above two steps (i.e., figure 6 and Figure 7) can be completed in one step:

Just select "Direct Generation" in "Database" à "database Generation":

Figure 8

This way, the entire process of using PowerDesigner to design the SQL Server database is complete!