Our database is a modern version of Northwind traders.
The data model is simple and has just 5 tables.
Download our script and create your own database + data.
Supports SQL Server 2014, 2016, 2017, and 2019.
Alternatively, use the live database in our SQL Editor.
ERD stands for Entity Relationship Diagram. It provides a visual overview of the database with tables and their relationships. Below is the ERD for our sample database.
ERD diagrams are an important tool for data professionals: they provide a wealth of information, about tables, columns, data types, relationships, primary keys, foreign keys, and indexes -- all in a single diagram.