Schematex
erd·Crow's-foot (Everest 1976) / DBML compatible·education, software·complexity 1/3

University schema (academic ERD)

Classic textbook schema with Student / Course / Enrollment associative entity and labelled relationships — the canonical Elmasri & Navathe ch.3 example.

For the database student

Open in Playground →
erd·§ —
↘ preview
100%
University Schema Entity-Relationship Diagram with 4 entities and 3 relationships. University Schema majors in Major major_id int PK name varchar Course course_id int PK title varchar credits int Student student_id int PK name varchar email varchar UK major_id int FK Enrollment student_id int PK FK course_id int PK FK grade char
UTF-8 · LF · 30 lines · 698 chars✓ parsed·1.0 ms·8.1 KB SVG

The university schema is the canonical introduction to associative entities. The M:N relationship between Student and Course is resolved through Enrollment, which carries the relationship attribute grade. Both Student and Course join Enrollment via composite primary keys (each FK column doubles as part of the PK).

ERD syntax →