Skip to content

education

sqllocks_spindle.domains.education

Education domain — academic institutions, students, courses, and financial aid.

Classes

EducationDomain

Bases: Domain

Education domain — academic institutions, students, courses, and financial aid.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - department: Academic departments - instructor: Faculty members - course: Course catalog - student: Enrolled students - enrollment: Course enrollments - financial_aid: Aid awards - course_section: Scheduled sections - grade_appeal: Grade appeals - academic_standing: Standing history

Methods:
star_schema_map()

Return the star schema mapping for the Education domain.

Produces
  • dim_student (from student)
  • dim_course (from course)
  • dim_instructor (from instructor)
  • dim_department (from department)
  • fact_enrollment (from enrollment)
  • fact_financial_aid (from financial_aid)
cdm_map()

Return the CDM entity map for the Education domain.

Maps source table names to Microsoft Common Data Model entity names.