Entity Relationship Diagram Examples

This example ER diagram shows how students, courses, instructors, and classrooms relate to each other in a typical university registration system. It's a great reference for learning ER modeling or as a starting template for similar systems. Tip: always mark cardinality (one-to-many, many-to-many) on each relationship line to avoid ambiguity.

Customize with AI — free Open in draw.io

The prompt behind this diagram

Create an example entity relationship diagram for a university course registration system with entities: Student, Course, Instructor, Department, Enrollment, and Classroom. Show Student to Enrollment as one-to-many, Course to Enrollment as one-to-many, Instructor to Course as one-to-many, Department to Instructor as one-to-many, Department to Course as one-to-many, and Course to Classroom as many-to-one for scheduling. Include primary key and foreign key attributes on each entity box.

Paste your own description (or Terraform / docker-compose / SQL schema) into draft1 and get a diagram like this for your exact system.

More templates

System Architecture Diagram

Generate a clear system architecture diagram online and export an editable draw.io file in seconds with AI.

Network Topology Diagram

Draw a network topology diagram instantly with AI and download it as an editable draw.io file for your documentation.

Aktivitätsdiagramm Für Eine Java-Methode Erstellen

Erstellen Sie ein UML-Aktivitätsdiagramm für Java-Methoden mit KI und exportieren Sie es als editierbare draw.io-Datei

Diagram Przypadków Użycia UML

Wygeneruj diagram przypadków użycia UML online za pomocą AI i pobierz edytowalny plik draw.io.

Cloud Architecture Diagram

Create a cloud architecture diagram with AI and export it instantly as an editable draw.io file.

Cloud Infrastructure Diagram

Generate a detailed cloud infrastructure diagram online using AI and export it as an editable draw.io diagram.

Business Process Flowchart With Decision Points

Build a business process flowchart with decision points using AI and download an editable draw.io file.