|
-
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
|
|
View course
View exam
