CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Education

🎓 Education · Database ERD

Course and Grades Database Schema

A database design for a school or university: students, courses, enrolments, assessments and grades, with the relationships between them.

More Education templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Enrolment links students to course offerings per term
  • Each assessment belongs to one course offering
  • Grades are stored per student per assessment

Prompt used

ERD for a university grades system: Student, Instructor, Course, CourseOffering (a course in a specific term taught by an instructor), Enrollment (student in an offering), Assessment (exam or assignment in an offering with a weight) and Grade (a student's marks for an assessment).

Mermaid code
erDiagram
  STUDENT ||--o{ ENROLLMENT : enrols
  COURSE ||--o{ COURSE_OFFERING : "offered as"
  INSTRUCTOR ||--o{ COURSE_OFFERING : teaches
  COURSE_OFFERING ||--o{ ENROLLMENT : has
  COURSE_OFFERING ||--o{ ASSESSMENT : includes
  ASSESSMENT ||--o{ GRADE : "graded in"
  STUDENT ||--o{ GRADE : receives
  STUDENT {
    int id PK
    string roll_no
    string name
    string email
  }
  COURSE {
    int id PK
    string code
    string title
    int credits
  }
  INSTRUCTOR {
    int id PK
    string name
    string department
  }
  COURSE_OFFERING {
    int id PK
    int course_id FK
    int instructor_id FK
    string term
  }
  ENROLLMENT {
    int id PK
    int student_id FK
    int offering_id FK
    date enrolled_on
  }
  ASSESSMENT {
    int id PK
    int offering_id FK
    string name
    decimal weight
  }
  GRADE {
    int id PK
    int student_id FK
    int assessment_id FK
    decimal marks
  }

Inside this diagram

An entity relationship diagram with 7 tables, 27 columns and 7 relationships.

Tables and their columns

  • STUDENT: id (PK), roll_no, name, email
  • ENROLLMENT: id (PK), student_id (FK), offering_id (FK), enrolled_on
  • COURSE: id (PK), code, title, credits
  • COURSE_OFFERING: id (PK), course_id (FK), instructor_id (FK), term
  • INSTRUCTOR: id (PK), name, department
  • ASSESSMENT: id (PK), offering_id (FK), name, weight
  • GRADE: id (PK), student_id (FK), assessment_id (FK), marks

Relationships

  • STUDENT enrols ENROLLMENT: each STUDENT has zero or more ENROLLMENT, each ENROLLMENT belongs to exactly one STUDENT
  • COURSE offered as COURSE_OFFERING: each COURSE has zero or more COURSE_OFFERING, each COURSE_OFFERING belongs to exactly one COURSE
  • INSTRUCTOR teaches COURSE_OFFERING: each INSTRUCTOR has zero or more COURSE_OFFERING, each COURSE_OFFERING belongs to exactly one INSTRUCTOR
  • COURSE_OFFERING has ENROLLMENT: each COURSE_OFFERING has zero or more ENROLLMENT, each ENROLLMENT belongs to exactly one COURSE_OFFERING
  • COURSE_OFFERING includes ASSESSMENT: each COURSE_OFFERING has zero or more ASSESSMENT, each ASSESSMENT belongs to exactly one COURSE_OFFERING
  • ASSESSMENT graded in GRADE: each ASSESSMENT has zero or more GRADE, each GRADE belongs to exactly one ASSESSMENT
  • STUDENT receives GRADE: each STUDENT has zero or more GRADE, each GRADE belongs to exactly one STUDENT

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

FlowchartEducation

Student Enrolment Workflow

The admission-to-enrolment journey at a college: application, document verification, merit list, fee payment and student ID.

C4 ArchitectureProEducation

Learning Management System Architecture

An LMS for a university or online course provider: courses, video lessons, assignments, quizzes, grades and live classes.

SequenceEducation

Online Exam Proctoring Sequence

How a remotely proctored online exam runs: identity check, environment scan, the timed exam with AI monitoring, and review of flagged events.

State MachineEducation

Assignment Submission Lifecycle

The states of a student assignment: draft, submission before or after the deadline, plagiarism check, grading, feedback and resubmission.

DeploymentProEducation

Live Classroom Streaming Deployment

How live online classes are delivered to thousands of students: the teacher's stream, media servers, recording and a CDN for replays.

C4 ArchitectureProEducation

University ERP Architecture

A university ERP: admissions, student records, fees, timetable, exams, HR and payroll, library and hostels in one system.