learnex

 
Data Modeling
  • · 
    Principles of data modelling

    • Entities
    • Attributes
    • Relationships
    • Keys
    • Entity descriptions

    ·  Data relationships

    • Cardinality
    • Optionality
    • Exclusivity
    • Recursion
    • Naming relationships
    • Relationship descriptions

    ·  Data modelling - further concepts

    • Attribute descriptions
    • Domain descriptions
    • Sub-types, super-types
    • Partitioning data models
    • Transferable and non-transferrable relationships
    • Entity aspects

    ·  Relational data analysis

    • Relations
    • Primary and candidate keys
    • Third normal form analysis

    ·  Drawing third normal form models

    • Rationalising the results of relational data analysis
    • Representing relations and keys
    • Rules for building the TNF model
    • Comparing the TNF model with the data model

    ·  Validating the data model

    • Validating against requirements
    • Access paths
    • Entry points and input attributes
    • Navigation
    • Volumetrics