Relational Data Modeling - Visualization

About

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

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
Foreign Keys (Associations Details)
Attributes (Details)

Figures

Documentation / Reference

  • Data Vault Presentation

Powered by ComboStrap