The Flow of Education Data

Overview

Education data follows a structured flow that reflects how students move through an institution—from admission to completion. Understanding this flow helps you connect tables and analyze operations correctly.

The process begins with admission, where student records are created in the students table and linked to a program using program_id.

Next is course registration, where students enroll in specific course sections. This is recorded in the enrollments table, linking student_id to section_id and term_id.

During class delivery, courses are taught through sections, and instructors are assigned. The sections and teaching_assignments tables capture how courses are delivered and who teaches them.

As students progress, academic performance is recorded in the grades table, which tracks scores and final outcomes.

Attendance data is captured in the attendance table, showing student participation and engagement throughout the course.

Advising systems support students along the way. The advising_sessions table records academic, career, and financial advising interactions.

Finally, tuition records are managed in the tuition_payments table, capturing billing, payments, and outstanding balances.

All these stages are connected through keys such as student_id, section_id, term_id, and program_id. This flow allows you to track a student from admission → enrollment → course delivery → performance → support → payment.

---

The Basic Pattern

SELECT column_name, COUNT(*) AS total
FROM table_name
GROUP BY column_name;
  

---

Examples

Example 1 — Count Students by Status (Admission Stage)

Example 2 — Count Enrollments by Final Status (Registration Stage)

Example 3 — Count Grades by Letter Grade (Performance Stage)

---

Practice Tasks (Your Turn!)

Task 1

Count the number of attendance records by attendance status.

Task 2

Count the number of advising sessions by advisor.

Task 3

Count the number of tuition records by term.