Data and databases

Data and databases

Data diagrams answer three separate questions: what the data is, where it is stored, and where it came from. Trying to answer all three in one diagram is the usual reason data documentation goes unread.

Almost everything here is better as text, because schemas change and text changes cheaply.


In this section

Entity relationship diagram

Create an ER diagram in Confluence. Compare Mermaid, ERD and DBML, then copy a working example.

Crow's foot notation

Read and write crow's foot notation: one-to-many, many-to-many, optional and mandatory cardinality.

Database schema diagram

Document tables, columns, types and foreign keys in Confluence from a text schema definition.

Data model diagram

Draw conceptual, logical and physical data models and pick the right notation for each level.

Star schema

Diagram a star or snowflake schema with a fact table at the centre and its dimension tables around it.

Data lineage diagram

Map lineage from source system through transformations to the dashboards that consume the data.

JSON structure diagram

Turn a JSON payload into a readable structure diagram for API docs and webhook contracts.


Get the cardinality right and the rest follows.

extension
extension