Introduction to the

PowerDesigner is a Data modeling tool that enables the design of Conceptual Data Models, Physical Data Models, object-oriented models (OOM), BPM models…

Model to understand

  • Conceptual data model (CDM) : The conceptual structure of an information system/functional module, including entities, attributes, and their relationships; Characteristic is more abstract, suitable for system analysis stage.
  • Physical data model (PDM) : According to the specific physical database, do detailed design for business/functional entities and associations. After the design, it can be directly used in the development, including table fields, stored procedures, operations, triggers, views and indexes, etc., which is applicable to the system design stage. Reference links: blog.csdn.net/tianlesoftw…

This article uses Windows10 and PowerDesigner 16.5 as an example to demonstrate how to use the tool

download

Ali cloud disk download link failure, please comment or private I 】 【 : www.aliyundrive.com/s/TmXTFKWT9…

Installation operation

  1. Click EXE, after default installation, paste the cracked files and DLL files in the Chinese package to the installation directory, and overwrite the files;
  2. run
    • Click to run the execution file:
    • If not, run this execution file:

CDM

model

  1. Click on the top left cornerfile, click on theThe new model, the CDM model is established, and the popover window is as follows:

  1. A common tool. After double-clicking the panel, it will be automatically pasted to the bottom of the menu bar. Double click again to restore it

The entity to build

  1. Left clickThe entity controls, placed in the design panel (Right click to cancel use,CTRL + Wheel to zoom in and out,The Delete key deletes the control)

  1. Design entity attributes

Property

  • M (Mandatory) \color{#FF0000}{M (Mandatory)}M (Mandatory) : Mandatory
  • P (PrimaryIdentifier) \color{#FF0000}{P (PrimaryIdentifier)}P (PrimaryIdentifier) : Primary key
  • D (Displayed) \color{#FF0000}{D (Displayed)}D (Displayed)

  1. Build additional entities to demonstrate the establishment of entity relationships

Establish a teacher entity

Create class entities

Entity relationship construction

Entity relationships are divided into one-to-one, one-to-many, many-to-one, and many-to-many

  1. To build the entity relationship (one-to-many) between the class and the students, click the association control in the tool to connect the two entities, class and student, and edit the information

The effect is as follows:

  1. Build the entity relationship (many-to-many) between teacher and student, click the association control in the tool, connect the two entities, teacher and student, and edit the information

The effect is as follows:

Turn the CDM PDM

CDM model is suitable for the analysis of system/functional structure and relationship, but for developers, it is not possible to directly use this model to do design work, so CDM model needs to be converted into PDM model, that is, the conceptual design into the specific application design of a database. In addition, you can also convert the CDM model into an object-oriented model, a logical object model… Not detailed here.

  1. Click on the menu bartoolButton, click in the drop down panelGenerate Physical Data Model...(The picture cannot be cut from the drop-down panel)

  1. Click “Apply” and “Confirm” to convert. The transformed model file will be saved in the same space. The transformation effect is as follows:

  1. Description:

After the transformation of PDM has been preliminary use, can generate a specific database table, fields and other SQL, if the design direction of the generation model, does not meet the company’s specifications, PDM model can be modified for the second time, such as: remove the exception key, increase the index and so on