Entity Relationship Diagrams
Hands-on tutorial
01 / THE CONCEPT
Understand the idea
In this lesson, explore entity relationship diagrams. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.
02 / SQL EXAMPLE
◉ example.sqlSQL
CREATE TABLE departments(id INTEGER PRIMARY KEY,name TEXT UNIQUE);Try in SQL Lab ↗03 / KNOWLEDGE CHECK
Check your understanding
Which statement best describes entity relationship diagrams?