logo
ExamplesEditorPricingDocs
37.1kSign in

Student information system (SIS) database schema

School administration in Oracle: students and guardians with custody and contact priority, enrolment history per school year, a period-based timetable with room allocation, attendance per lesson, discipline records, transcripts and a fee ledger.

Student Information ER diagram

Student information system (SIS) database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 students idNUMBER student_numberVARCHAR2 legal_surnameVARCHAR2 legal_given_namesVARCHAR2 preferred_nameVARCHAR2 date_of_birthDATE gender_codeVARCHAR2 home_language_codeCHAR has_medical_planNUMBER photoBLOB created_onDATE guardians idNUMBER surnameVARCHAR2 given_namesVARCHAR2 relationship_defa…VARCHAR2 mobile_phoneVARCHAR2 home_phoneVARCHAR2 emailVARCHAR2 address_lineVARCHAR2 postcodeVARCHAR2 preferred_languag…CHAR student_guardians student_idNUMBER guardian_idNUMBER relationshipVARCHAR2 contact_priorityNUMBER has_legal_custodyNUMBER has_parental_resp…NUMBER may_collect_stude…NUMBER receives_reportsNUMBER restriction_noteVARCHAR2 lives_with_studentNUMBER school_years idNUMBER year_codeVARCHAR2 starts_onDATE ends_onDATE census_dateDATE teaching_daysNUMBER is_currentNUMBER staff idNUMBER staff_numberVARCHAR2 surnameVARCHAR2 given_namesVARCHAR2 titleVARCHAR2 emailVARCHAR2 role_codeVARCHAR2 started_onDATE left_onDATE rooms idNUMBER room_codeVARCHAR2 buildingVARCHAR2 capacityNUMBER room_typeVARCHAR2 is_accessibleNUMBER is_bookableNUMBER periods idNUMBER school_year_idNUMBER period_codeVARCHAR2 sequence_noNUMBER starts_atVARCHAR2 ends_atVARCHAR2 session_codeVARCHAR2 is_registrationNUMBER enrollments idNUMBER student_idNUMBER school_year_idNUMBER year_groupVARCHAR2 registration_groupVARCHAR2 homeroom_staff_idNUMBER entry_dateDATE leaving_dateDATE leaving_reasonVARCHAR2 enrollment_statusVARCHAR2 is_fundedNUMBER timetable_entries idNUMBER school_year_idNUMBER subject_codeVARCHAR2 teaching_setVARCHAR2 period_idNUMBER day_of_weekNUMBER week_patternVARCHAR2 staff_idNUMBER room_idNUMBER expected_sizeNUMBER subject_registratio… idNUMBER enrollment_idNUMBER subject_codeVARCHAR2 teaching_setVARCHAR2 started_onDATE ended_onDATE final_gradeVARCHAR2 grade_pointsNUMBER creditsNUMBER counts_towards_gpaNUMBER is_transcript_vis…NUMBER attendance_marks idNUMBER enrollment_idNUMBER timetable_entry_idNUMBER mark_dateDATE attendance_codeVARCHAR2 minutes_lateNUMBER reason_noteVARCHAR2 recorded_by_staff…NUMBER recorded_atTIMESTAMP amended_reasonVARCHAR2 discipline_incidents idNUMBER student_idNUMBER school_year_idNUMBER occurred_onDATE categoryVARCHAR2 severityNUMBER locationVARCHAR2 descriptionCLOB sanctionVARCHAR2 sanction_daysNUMBER reported_by_staff…NUMBER guardians_informe…DATE is_confidentialNUMBER fee_ledger idNUMBER student_idNUMBER school_year_idNUMBER entry_typeVARCHAR2 categoryVARCHAR2 descriptionVARCHAR2 amount_minorNUMBER currency_codeCHAR due_onDATE posted_atTIMESTAMP payment_methodVARCHAR2 external_referenceVARCHAR2 reverses_entry_idNUMBER

Related database schemas

MySQL
Education

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.

PostgreSQL
Education

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.

PostgreSQL
Education

Duolingo-style language learning database schema

How a gamified language app models its data: directional courses, a skill tree with unlock rules, lessons and exercise items, crown levels, a per-word spaced-repetition schedule, streaks with freezes, hearts and weekly leagues.

MySQL
Education

Public library catalog and circulation database schema

How a public library models its data: works, editions and barcoded copies, branches and holdings, members, loans with renewals, a positioned hold queue, fines and payments, and inter-branch transfers.