PowerDesigner Introductory Introduction

I have always claimed that I would use powerdesigner, this time really to use in the project to know, I just will see powerdesigner The picture is not used. Although I still feel I'm not going to use it, it's at least an entry level. Let's talk about how I get started.

First, Introduction

PD is a graphical modeling environment that leverages PD You can create a data flow diagram, a conceptual data model, a physical data model, and generate the appropriate code from the model, if shown:

let's start with the model that I've touched., PDcan be completed: Conceptual data Model (CDM), the logical data model (LDM),Physical Data Model (PDM), Object-oriented model (OOM),Business Process Model (BPM) IfCdm,pdm,oomThe conversion relationship of the three:

Second, use

for this system, start with the design entity, but if the export entity code needs an object-oriented model, if it is necessary to export the database is a physical data model, because there is a relationship between the graph and the diagram can be converted, after my research found that The object-oriented model cannot set the entity's primary foreign key, the database design is not enough abstract, this time the concept data model design is most suitable, because the CDM can not only indicate the relationship between entities, but also can specify the primary foreign key, so that we can automatically generate the model we want.

So I'll start with the steps to create a conceptual data model:

1 , File -newmodel Select: Conceptual Data Model ( CDM ) --ok

2 , create an entity, and name the entity after it is created:

3 , add attributes for the entity:

4 , the relationship between entities and entities:

There are four basic types of relationships:

The corresponding diagram is as follows:

I created a relationship between the student and the curriculum and the teacher, they are many-to-many relationships, that is, students can correspond to many courses, the course can correspond to multiple students, teachers corresponding to many courses, courses can also correspond to multiple teachers: relationship:

if we want to convert into OOM the graph can be: Tools --

(1) converted into OOM :

(2) converted into PDM : (The third table is automatically generated based on the relationship of many pairs of pairs)

For the time being, this is a very powerful tool that has temporarily only developed so many, welcome additions.

PowerDesigner Introductory Introduction