School & learning management system database schema
Courses versus sections, terms, enrolments that carry the final grade, prerequisites as a self-join, assignments with weights, per-attempt submissions and idempotent attendance registers.
School LMS ER diagram
Related database schemas
Project management & issue tracker database schema
A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.
Hospital / EHR database schema
The core of an electronic health record: patients and providers, appointments versus encounters, coded conditions and observations, prescriptions against a drug catalogue, allergies and insurance coverage over time.
Hotel booking & reservation database schema
A reservation system that actually handles availability: room types versus rooms, rate plans, a per-night rate and inventory calendar, reservations broken down by night, payments and verified reviews.
Coursera-style online course platform database schema
How a MOOC platform models its data: versioned course content, dated session runs, an outline tree of modules and lectures, quizzes drawn from question banks, peer-graded assignments with rubric criteria, entitlements and certificates.