Erd Go Journal

Database Design & SQL Guides

Practical guides to ERD Builder, Chen notation, EER modeling, SQL DDL, schema design, normalization, indexes, and database relationships.

All guides

Executable customer and order SQL beside matching tables and a required customer foreign key

ERD Tools

How to Convert SQL Schema to an ERD Diagram Automatically

Turn your SQL DDL into a visual ERD in seconds — paste your CREATE TABLE statements and get an interactive database diagram automatically.

PostgreSQL BIGSERIAL and TIMESTAMPTZ columns with a customer-to-order foreign key diagram

ERD Tools

PostgreSQL ERD Generator: Visualize Tables, ENUMs, and Foreign Keys

PostgreSQL schemas often include enums, identity columns, arrays, and rich constraints. See how to turn that DDL into a readable ERD automatically.

Readable customer, order, and order-item tables with keys and explicit relationship endpoints

ERD Tools

Free Online ERD Tool: Design Database Diagrams from SQL

A practical checklist for choosing an online ERD tool, with a SQL-first workflow for generating, editing, exporting, and sharing diagrams.

A customer-to-order diagram beside notes explaining the foreign key and business rule

Database Design

Database Documentation: Use ERDs to Explain Your SQL Schema

Turn raw SQL into documentation your team can actually use: ERDs, table notes, relationship explanations, and migration context in one workflow.

Equivalent customers and orders schemas written in SQL DDL for Erd Go and DBML for dbdiagram.io

Comparisons

Erd Go vs dbdiagram.io: Which SQL to ERD Tool Should You Use?

A practical comparison of Erd Go and dbdiagram.io for developers who want fast SQL-to-ERD diagrams, schema review, and database documentation workflows.

SQL DDL beside a visual customers and orders model for comparing Erd Go and DrawSQL workflows

Comparisons

Erd Go vs DrawSQL: SQL-First Database Diagram Tool Comparison

Compare a SQL-first editor with a collaborative diagram workspace, including SQL import, sharing, and the tools that fit each workflow.

SQL schema source beside a relational diagram for comparing Erd Go and Lucidchart workflows

Comparisons

Erd Go vs Lucidchart: Database ER Diagram Workflows

Compare Erd Go’s SQL-to-ERD editor with Lucidchart’s schema import, visual diagramming, and collaboration workflows.

Chen model of Customer placing Order, with underlined identifiers, min-max cardinality, and total Order participation

ERD Tools

How to Use ERD Builder: Draw an ER Diagram Without SQL

Build your first conceptual database diagram from a blank canvas, then review its relationships and export a clear diagram for your team.

Nine precise Chen symbols, including weak entities, identifying relationships, partial keys, and derived attributes

Database Design

Chen Notation ERD Guide: Symbols, Keys, and Cardinality

Understand the shapes and constraints in a Chen ER diagram, then apply them to a Customer, Order, and Order Line model.

Person specializes into overlapping Student and Instructor subtypes; Owner is a category drawn from Person and Company

Database Design

EER Diagrams in ERD Builder: ISA, Categories, and Aggregation

Go beyond basic entities and relationships. Model subtype rules, union categories, and relationships that participate in higher-level relationships.

Customers, orders, and order items with primary keys, foreign keys, and one-to-many cardinality

Database Design

What is an Entity Relationship Diagram (ERD)? A Complete Guide

A comprehensive guide to Entity Relationship Diagrams — understand entities, attributes, relationships, cardinality, and learn how to visualize your database schema effortlessly.

CREATE TABLE, ALTER TABLE, and DROP TABLE examples for the same products table

SQL

SQL DDL Cheat Sheet: CREATE, ALTER & DROP Statements Explained

Your go-to reference for SQL DDL statements — CREATE TABLE, ALTER TABLE, data types, and constraints across PostgreSQL, MySQL, and SQL Server.

Database normalization from 1NF to 3NF, splitting order lines into products, orders, and customers

Database Design

Database Normalization: 1NF, 2NF, 3NF Explained with Examples

Understand database normalization step by step — from 1NF to 3NF with practical SQL examples. Learn when normalization helps and when denormalization makes sense.

Customer primary key 42 referenced by order foreign keys, with a concrete SQL constraint

SQL

Primary Keys vs Foreign Keys: The Foundation of Database Relationships

Primary keys identify rows uniquely; foreign keys link tables together. Master both to build solid, well-connected database schemas.

Requirements become entities, relationships, and a SQL schema with customer and order keys

Database Design

How to Design a Database Schema from Scratch: A Step-by-Step Guide

A practical, step-by-step walkthrough for designing a database schema from requirements to SQL — covering entity identification, relationships, and constraints.

Equivalent identity columns using PostgreSQL GENERATED AS IDENTITY, MySQL AUTO_INCREMENT, and SQL Server IDENTITY

SQL

PostgreSQL vs MySQL vs SQL Server: Which Database Should You Choose?

Compare PostgreSQL, MySQL, and SQL Server syntax, version-specific features, editions, and practical criteria for choosing a database.

Products table with NOT NULL, UNIQUE, non-negative price CHECK, and DEFAULT zero

SQL

SQL Constraints Explained: NOT NULL, UNIQUE, CHECK, DEFAULT & More

Constraints are the guardrails of your database. Learn how NOT NULL, UNIQUE, CHECK, DEFAULT, and key constraints keep your data clean and consistent.

Customer-to-order foreign key and student-to-course junction table with a composite primary key

Database Design

One-to-Many vs Many-to-Many: SQL Relationship Patterns Explained

The two most common relationship patterns in databases — learn how to model one-to-many and many-to-many with foreign keys and junction tables.

Composite index example beside a B-tree lookup following the path from 40 through 60 to key 50

Performance

Database Indexing Strategies: Speed Up Your SQL Queries

Indexes can make or break your query performance. Learn which indexing strategies actually work and the common mistakes that silently slow everything down.

Two worksheet rows converted into typed SQLite CREATE TABLE and INSERT statements

SQL

How to Convert Excel and CSV Files to SQL Tables

Turn messy spreadsheet data into clean SQL tables. Learn how to infer column types, preview rows, and generate CREATE TABLE plus INSERT statements.