如何建立数据模型（How to build data model）.docVIP

如何建立数据模型（How to build data model） How to build a data model, generally as a rookie level database designers, often face a project, do not know how to start Or grab a piece of paper and start the analysis Or the method is unitary, cannot find the corresponding CASE tool at all Or miss the point; or dont know what he was doing, the book says to do so. Thats how I came here Here, in conjunction with your usual analytical experience, talk about how to build data models What is the data model? Teacher Wang Shan tells us: data model is the simulation of the real world. My understanding of data model design is the design of database So what should be good data models? She should meet 3 demands: First, it can simulate the real world more realistic Two is easy to understand Three is easy to implement on the computer. The establishment of the data model is generally divided into four steps: 1, demand analysis, 2 conceptual model design, 3 force model design, 4 implementation, operation and maintenance Powerdesigner12 has no PAM and is replaced by BPM 1 when we need analysis, we use the following auxiliary methods: The business process diagram is recommended for PD implementation The data dictionary is recommended for PD implementation Data flow diagram recommended VISIO implementation, PD under BPM The system flow diagram suggests VISIO implementation The organizational chart is recommended for VISIO implementation The timing diagram is recommended for VISIO implementation Statecharts are recommended for VISIO implementation A functional decomposition diagram is proposed for VISIO implementation 2 when designing conceptual models, we use the following helper methods: The ER diagram suggests a CDM implementation of PowerDesigner The data dictionary suggests the Report implementation of PowerDesigner Model optimization paradigm verification The design of user mode to meet the users habits, to achieve safety 3 physical model design The database structure suggests the PDM impleme