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

如何建立数据模型（How to build a data model） How to build a data model is generally used as a database designer at a rookie level, often facing a project and not knowing how to proceed. Or grab a piece of paper and start analyzing it. Or the method is single, cannot find the corresponding CASE tool at all. Or may not lead; Or if you dont know what youre doing, the book says youre going to do that. Thats how I came here. Heres how to build a data model. What is a data model? Wang shan told us: the data model is the simulation of the real world. My understanding of the data model design is the design of the database So what does a good data model look like? She should meet three requirements: One is to be able to compare the real world Second, it is easy to understand Third, it is convenient to realize on the computer. The establishment of data model is generally divided into four steps: 1 demand analysis 2 conceptual model design 3 physical force model design 4 implementation operation maintenance Powerdesigner12 has no PAM and is replaced by BPM. 1. We use the following auxiliary methods for demand analysis: The business flowchart is recommended for PD implementation The data dictionary recommends PD implementation The data flow diagram recommends that VISIO implement BPM under pd The system flowchart recommends VISIO implementation The organization chart recommends VISIO implementation The sequence diagram recommends that the VISIO implementation be implemented The status diagram recommends that the VISIO implementation be implemented The functional decomposition diagram recommends VISIO implementation 2 conceptual model design we use the following auxiliary methods: ER diagram recommends that PowerDesigners CDM implementation be implemented The data dictionary recommends PowerDesigners Report implementation Model optimization paradigm Designing user subpatterns is consistent with user habits and security 3 physical model design The database structure recommends the PDM imp