Data Modeling Activities
저자: Do Trung Hieu
1. Conceptual Data Model (CDM)
1.1. Select Scheme
1.2. Select Notation
1.3. Complete Initial CDM
1.3.1. capture viewpoint of user group
1.3.2. should NOT complicate
1.3.3. Collect highest level concept (noun)
1.3.4. Common concepts (Time; Geography, Customer, Product, Service....)
1.3.5. Collect Verb --> Connect these concepts
1.4. Incorporate Enterprise Terminology
1.5. Obtain Sign Off
2. Logical Data Modeling
2.1. Analyze Information Requirement
2.1.1. Identify Information needs of one or more Biz Process
2.2. Analyze Existing Documentation
2.3. Add Associative Entities
2.3.1. Describe Many to Many Relationship
2.3.2. Usually become Fact tables
2.4. Add Attributes
2.5. Assign Domain
2.6. Assign Key
2.6.1. Key attribute help identify one unique instance from all others
3. Physical Data Modeling
3.1. Resolve Logical Abstractions
3.1.1. Subtype absorption
3.1.2. Subtype partition
3.2. Add attribute details
3.2.1. technical name of table and column
3.2.2. physical data type, data length, NULL or NOT NULL constraints