Table of Contents

About

The vizualization of a relational data model is done as a sepecialized Entity relationship diagram.

Erd Graphical Notation

A best practice is to draw the child table above the parent table.

Color

One way to see the different data models is to colour the relation by the main characteristic of their columns.

Colours Legends

Main attributes Colour
Business Keys Blue
Foreign Keys (Associations Details) Red
Attributes (Details) Yellow

Figures

3nf Color Star Schema Color
Data Vault Colour Data Vault Skeleton Colour

Documentation / Reference

  • Data Vault Presentation