HomeDiagramsER diagramER: School Management Schema

ER: School Management Schema

School system with students, teachers, courses, and enrollments.

er-school-management-schema.mmd
erDiagram
  STUDENT {
    int id PK
    string name
    date dob
    string grade
  }
  TEACHER {
    int id PK
    string name
    string department
  }
  COURSE {
    int id PK
    string title
    int teacher_id FK
    int credits
  }
  ENROLLMENT {
    int id PK
    int student_id FK
    int course_id FK
    string semester
    float grade
  }
  TEACHER ||--o{ COURSE : teaches
  STUDENT ||--o{ ENROLLMENT : enrolled
  COURSE ||--o{ ENROLLMENT : has
Output
ER diagram, Zombie Mermaid STUDENT PK int id string name date dob string grade TEACHER PK int id string name string department COURSE PK int id string title FK int teacher_id int credits ENROLLMENT PK int id FK int student_id FK int course_id string semester float grade teaches enrolled has

More ER diagram examples

ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Basic Relationship
ER diagram, Zombie Mermaid CUSTOMER PK int id string name UK string email date created_at
ER: Entity with Attributes
ER diagram, Zombie Mermaid ORDER PK int id FK int customer_id UK string invoice_number decimal total date order_date string status
ER: Attribute Keys (PK, FK, UK)
ER diagram, Zombie Mermaid PERSON (no attributes) PASSPORT (no attributes) has
ER: Exactly One to Exactly One (||--||)
ER diagram, Zombie Mermaid CUSTOMER (no attributes) ORDER (no attributes) places
ER: Exactly One to Zero-or-Many
ER diagram, Zombie Mermaid SUPERVISOR (no attributes) EMPLOYEE (no attributes) manages
ER: Zero-or-One to One-or-Many