How to design a SQL Server database with PowerDesigner

Source: Internet
Author: User
Tags microsoft sql server microsoft sql server 2005 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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.