Occupation

Data modeller

Competence: Data modelling. Topic: Data modelling and design (DAMA-DMBOK2 chapter 5). Can be tested

How the stages build on each other

Arrows run from a stage to the stages that build on it.

Stage 1

Capture data requirements
Captures atomic, sourced and testable data requirements
47 knobits (12 knowledge, 35 skills) · Produces: data requirement
Stage 2

Define business terms
Defines business terms in a glossary, free of circularity, homonyms and hidden rules
20 knobits (7 knowledge, 13 skills) · Produces: business term · Builds on: Stage 1
Stage 3

Document data rules as SBVR fact types and rule statements
Documents data rules in SBVR and resolves rule anomalies
28 knobits (7 knowledge, 21 skills) · Produces: data rule · Builds on: Stage 2
Stage 4

Build the conceptual model and taxonomies
Builds a conceptual model and its taxonomies
31 knobits (8 knowledge, 23 skills) · Produces: taxonomy · Builds on: Stage 3
Stage 5

Derive the logical data model
Derives a normalised logical data model and traces anomalies to their causes
56 knobits (20 knowledge, 36 skills) · Produces: logical model · Builds on: Stage 4
Stage 6

Design the physical data model
Designs a physical data model for the target platform without introducing anomalies
42 knobits (12 knowledge, 30 skills) · Produces: physical model · Builds on: Stage 5
Stage 7

Derive data quality rules
Derives data quality rules from the data rules and the physical model
34 knobits (8 knowledge, 26 skills) · Produces: data quality rule · Builds on: Stage 6, Stage 3
Stage 8

Generate and review DDL
Generates DDL per target dialect and reviews it against model, engine, data and deployment
37 knobits (9 knowledge, 28 skills) · Produces: generated DDL · Builds on: Stage 7, Stage 6