PowerDesigner Use tutorial (i)

I. Introduction of PowerDesigner

PowerDesigner is a very powerful modeling tool software that is just as good as Rose and is one of the most famous modelling software today. Rose is a modeling tool that specializes in the UML object model before it is modeled on the database, and PowerDesigner is the opposite of it, which started as a database model and later developed into a comprehensive case tool.

PowerDesigner is divided into 7 types of modeling files:

1. Conceptual data Model (CDM)

Modeling data and information, using entity-Relationship diagram (e-r) Form to organize data, verify the validity and rationality of data design.

2. Logical data Model (LDM)

PowerDesigner 15 new models. The logical model is an extension of the conceptual model, which represents the logical order between concepts and is a model that belongs to the method hierarchy. In particular, the logical model shows the relationships between entities, attributes of entities, and entities on the one hand, as well as inheritance, references in entity relationships, and so forth in the attributes of entities. The logical model is between the conceptual model and the physical model, with the characteristics of the physical model, the many-to-many relationships in the conceptual model, which will be implemented by increasing the one-to-many relationship of the intermediate entities in the logical model.

The logical model is to make the whole concept model easier to understand, without relying on the specific database implementation, the logical model can be used to generate a physical model for the specific database management system. The logical model is not required throughout the step, and can be generated directly from the conceptual model.

3. Physical data Model (PDM)

Based on the specific DBMS, the design is based on the conceptual data model and logical data model. Generate a database from a physical data model, or reverse engineer a database to get a physical data model.

4. Object-oriented model (OOM)

Contains all the graphics common to UML: Class diagram, object graph, package diagrams, use case diagram, time series diagram, collaboration diagram, interaction diagram, activity diagram, state diagram, Component diagram, composite structure diagram, deployment diagram (configuration diagram). OOM is essentially a static conceptual model of a software system.

5. Business Process Model (BPM)

BPM describes the various internal tasks and internal processes of the business, and how customers interact with these tasks and processes. BPM is a conceptual model of business logic and rules from the point of view of a business partner, using a diagram to describe the interactions between programs, processes, information, and cooperation agreements.

6. Information flow model (ILM)

ILM is a high-level information flow model that is primarily used for data replication between distributed databases.

7. Enterprise Architecture Model (EAM):

From the business layer, the application layer and the technical layer of the Enterprise's architecture for a full description. Include: Organization chart, business communication diagram, process diagram, City plan diagram, application frame composition, service oriented diagram, technical framework diagram.

Second, PowerDesigner Basic use (take PowerDesigner15 as an example)

1. Now start using PowerDesigner to create the physical data model, first run the program and go to the main interface:

2.file-new model-physical Data model-physical Diagram

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

4. Double-click the table template to set the properties:

5. Set the table name, click the Columns tab, set the field properties, set:

6. If the field is set to a default value, we open the advanced properties of the corresponding field, such as:

7. Set the relationship between the two tables, such as:

PowerDesigner Use tutorial (i)