Example ERD

Relational Data Modeling

Entities with attributes and keys; relationships between entities.

Page contents

Overview

This page includes three versions of the same ERD, consisting of (and expanding somewhat on) the example entities, relationships, and keys described in the previous sections. One ERD is shown without data types or index indicators; one has index indicators and SQLite datatypes; and one has index indicators and H2 datatypes. All of the diagrams were created in diagrams.net, and the source files are linked below.

No data types

ERD without data types

erd-no-types.drawio

SQLite data types

ERD with SQLite data types

erd-sqlite-types.drawio

H2 data types

ERD with H2 data types

erd-h2-types.drawio