Databases

LMS Modules, Quizzes, & Submissions Schema

ER Diagrams · made in Skemio

ER diagram detailing courses, modules, quizzes, questions, and quiz_attempts showing relational hierarchies and attempt tracking.
ER diagram detailing courses, modules, quizzes, questions, and quiz_attempts showing relational hierarchies and attempt tracking.
Open it in SkemioMake your own

What it shows

  • Modules use strict sort ordering to control curriculum progression
  • Questions decouple from attempts to allow live rubric updates
  • Attempts snapshot total score and completion state independently

The takeaway

Separate curriculum blueprints from evaluation attempts to keep student submissions immutable.

More er diagrams