系统分析与设方法-第七版-影印版.pptVIP

Data MODELING AND Analysis What Is Data Modeling? Data modeling is a technique for organizing and documenting a systems data. Data modeling is sometimes called database modeling because a data model is usually implemented as a database. System Concepts For Data Modeling Entities a class of persons,places,objects,events,or concepts about which we need to capture and store data. Attributes a descriptive property or characteristic of an entity.Synonyms include element,property,and field. Relationships a natural business association between one one or more entities. Relationships ? nonidentifying relationshi a relationship in which each participating entity has its owm independent primary key. ? identifying relationship a relationship in which the parent entitys key is also part of the primary key of the child entity. ? nonspecific relationship a relationship where many instances of an entity are associated with many instances of another entity.Also called many-to-many relationship. The Process Of Logical Data Modeling Strategic Data Modeling Data Modeling during Systems Analysis Looking Ahead to Systems Design Automated Tools for Data Modeling How to Construct Data Models Entity Discovery The Context Data Model The Key-Based Data Model Generalized Hierarchies The Fully Attributed Data Model Analyzing the Data Model ? What is a Good Data Model? 1. A good data model is simple. 2. A good data model is essentially nonredundant. 3. A good data model should be flexible and adaptable to future needs. ? Data Analysis a technique used to improve a data model for implementation as a database. ? Normalization Example a data analysis technique that organizes data into groups to form nonredundant,stable,flexible,and adaptive entities. Normalization ? first normal form(1NF) an entity whose attributes have no more than one value for a single instance of tha