Power Designer Tool Tutorial In Business Analyst

PowerDesigner is a CASE (Computer Aided Software Engineering) tool launched by Sybase that integrates enterprise architecture, UML (Unified Modeling Language) and database. It can not only be used in different stages of system design and development (that is, business analysis, conceptual model design, physical model design, and object-oriented development stages), but also can meet the needs of management, system design, development and other related personnel. It is the industry's first modeling software that provides business analysis, database design and application development at the same time.

PowerDesigner 15 containsProject, Repository, Addins&Plug-inas well as9 models(Enterprise Architecture Model-EAM, Demand Model-RQM, Information Flow Model-ILM, Business Process Model-BPM, Conceptual Data Model-PDM, Object-Oriented Model-OOM, XML Model-XSM)。

Nine modules cover all stages of the software development life cycle.

PowerDesigner 15 also provides a model document editor, which is used to build models for each module to generate detailed documents, so that relevant personnel have a clear understanding of the entire system.

PowerDesigner is mainly divided into 7 types of modeling files:

1. Conceptual Data Model (CDM)

Model data and information, organize data in the form of entity-relation diagram (E-R diagram), and test the validity and rationality of data design.

2. Logical Data Model (LDM)

PowerDesigner 15 new model. The logical model is an extension of the conceptual model, representing the logical sequence between concepts, and is a model belonging to the method level. Specifically, on the one hand, the logical model displays entities, their attributes, and the relationships between entities; on the other hand, inheritance and references in entity relationships are displayed in entity attributes. The logical model is between the conceptual model and the physical model, and has the characteristics of the physical model. The many-to-many relationship in the conceptual model will be realized in the logical model by increasing the one-to-many relationship of intermediate entities.

The logical model is mainly to make the whole conceptual model easier to understand, and at the same time does not depend on the specific database implementation. The logical model can be used to generate a physical model for a specific database management system. The logical model is not necessary in the whole step, and the physical model can be generated directly through the conceptual model.

3. Physical Data Model (PDM)

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

4. Object-Oriented Model (OOM)

Contains all the common UML graphics: class diagram, object diagram, package diagram, use case diagram, sequence 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 influence each other with these tasks and processes. BPM is a conceptual model of business logic and rules from the perspective of business partners. It uses a diagram to describe the interaction between procedures, processes, information, and cooperation agreements.

6. Information Flow Model (ILM)

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

7. Enterprise Architecture Model (EAM):

From the business layer, application layer and technical layer to the full description of the enterprise architecture. Including: organization chart, business communication diagram, process diagram, city planning diagram, application architecture diagram, service-oriented diagram, technical basic framework diagram.

As the saying goes, "Workers must first sharpen their tools". PowerDesigner is a powerful "artifact". If you can use it freely, and then have "peerless martial arts", then you will basically kill the gods and the Buddhas. Up!

Take a look at how to quickly create this database with PowerDesigner.

1. Now start to use PowerDesigner to create a database, first run the program and enter the main interface:

2.File—>New Model—>Physical Data Model—>Physical Diagram—>Model name

Set to test, and set the DBMS property to Mysql5.0:

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

1.) Click to select the form tool 2.) Then create a new form in the blank space.

4. Double-click the form template, set the properties, we first setuser_base_info table:

In addition, you can modify the name and add notes.

5. Set the table name, clickColumnsLabel, set the field properties, and the settings are as shown in the figure:

6. Because the id field we want to set toAutomatic growth, So to set its advanced properties, select the id field, click the properties button, and check the Identity check box in the General panel:

7. Preview the sql statement.

drop table            if                          exists user_base_info;                        /*            ==============================================================            */            /*                          Table: user_base_info                        */            /*            ==============================================================            */                          create table user_base_info (    id                        int            not            null                          auto_increment,    nickname             varchar(            32            ),    real_name            varchar(            32            ),    cellphone            varchar(            20            ),    status               varchar(            11            ),    primary key (id) );  alter table user_base_info comment                        '            Remarks: user basic information table            ';

8. After confirming, we will create a user_car_auth table, the field settings are as shown in the figure:

9.Next is to create a user_base_info foreign key for user_car_auth.

Using PowerDesigner can easily complete this work, select the relationship setting tool, hold down the left button on the user_car_auth table, and drag it to the user_base_info table, you can add a user_id foreign key to the user_car_auth table:

PowerDesigner design database commonly used script

PowerDesigner design database commonly used script Database Design Physical model settings Name to comment script Note Turn Name Scripts ABLE adds prefixed scriptures Corresponding data type Types of ...