Powerdesinger: Physical Data Model (relational table), Entity diagram,->sql statement-database

I've heard of it before, in the project. Powerdesinger , but has never been used, this time through the foundation of the elective module finally has the opportunity to pass Powerdesinger of the CDM model to create a database.

Powerdesinger There are several data models in the system, namely: M----Model,

1. Conceptual Data Model ( CDM ) Conceptual Diagram Model

1. logical Data Model ( LDM )

1. Physical Data Model ( PDM ) Physical Diagram Model

1. Object-oriented model ( OOM )

1. Business Process Model ( BPM )

Degree of Abstraction ( lower in descending order ) :

Cdm->ldm->pdm

Powerdesinger is the ability to generate a physical data model from a conceptual data model and then generate the database directly from the resulting physical data model. Now let's take a look at the specific steps:

1. First, let's draw a good entity Relationship diagram:
   1. The representation of the entity is the same as ours, but the relationship here is somewhat different.

Select TextBox in the

then connect two entities to the drawing area and double-click on the picture. " Contact ", we can see

1. Note In an Entity Relationship diagram, there is no inclusion relationship between entities, and there is a simple association between individual entities.

1. An association between entities should have its own name.

through Select Select the icon you want to convert

1. Transform a well-drawn entity diagram into a physical data model

2. entity Relationship One-to-one relationships in each " a " contains another " a id
4. one-to-many relationships in entity relationships , in multiple " square Each record in span lang= "ZH-CN" style= "font-size:12pt" contains " a " id
6. a many-to-many relationship in an entity relationship that generates each record containing each " more " Party's ID another table.

Creating database scripts using the physical data model

1. position the active window in the PDM in the toolbar, click database->generate DataBase, get the Build database SQL statement.

1. by executing SQL statement, we can generate the corresponding data tables and databases.

Powerdesinger: Physical Data Model (relational table), Entity diagram,->sql statement-database