The departments table defines the five academic units that organise the college’s academic offerings. Each department belongs to a campus and a faculty, and is referenced by the instructors, programs, and courses tables. Understanding this table is essential for any query that groups or filters data by academic area.

The instructors table stores information about the five teaching staff members. Each instructor belongs to a department, has a hire date, an employment type (Full-Time or Contract), and an active flag. This table is referenced by the teaching_assignments table, which connects instructors to the course sections they teach.

The programs table defines the five credential offerings available at the college. Each program belongs to a department, has a credential type (Degree, Masters, Diploma, or Certificate), a duration in years, and an active flag. Students are linked to a program through their record in the students table.

The students table holds demographic and enrollment information for all eight students in the database. Students come from Victoria, Vancouver, Calgary, Toronto, Langford, Surrey, and Burnaby. Their statuses vary: Active, Inactive, and Graduated — making this table ideal for practising status-based filtering and cohort analysis.

The terms table defines the three academic terms in the 2024/2025 academic year. Each term has a start date, an end date, and an academic year label. The term_id is referenced by both the sections and tuition_payments tables, linking when courses run to when fees are due.

The courses table lists the six courses offered by the college. Each course has a unique code (e.g., BUSA101), a name, a department, a credit hour value, and a level (Undergraduate or Graduate). The courses table is referenced by the sections table, which assigns courses to specific terms and campuses.

The sections table represents individual scheduled offerings of a course. A single course can have multiple sections across different terms or campuses. Each section specifies the delivery mode (In-Person, Online, or Hybrid), the room or virtual space, and the maximum capacity. Sections are referenced by both teaching_assignments and enrollments.

The teaching_assignments table links instructors to the sections they teach. Each row represents one instructor assigned to one section, with a date of assignment and a teaching role. All six assignments in this dataset are Lead Instructor roles. Note that instructor 2 (James Patel) is assigned to two sections — 301 and 303 — which is a realistic pattern that supports workload analysis queries.

The enrollments table records which students are registered in which sections. With 9 records across 8 students and 6 sections, this dataset includes students enrolled in multiple sections, a withdrawn student, and records with both Completed and In Progress statuses — giving you realistic variety for status-based filtering and completion analysis.

The grades table records the final assessment result for each completed or withdrawn enrollment. With 7 grade records across a range from A+ (91) to F (52), this table supports performance analysis, grade distribution queries, and pass/fail classification using CASE WHEN. Note that In Progress enrollments do not yet have grade records.

The attendance table records individual attendance events for enrolled students. Each row logs one student’s attendance on one date, including whether they were present or absent and how many minutes they attended. With 9 records spanning both Fall 2024 and Spring 2025 sessions, this table is ideal for attendance rate calculations and at-risk student identification.

The tuition_payments table records financial transactions between students and the college. Each row represents one student’s tuition for one term, including the amount billed, the amount paid, payment status, and payment method. With three different payment statuses (Paid, Partially Paid, Outstanding), this table supports financial reporting and accounts receivable queries.

The advising_sessions table logs meetings between students and their advisors. Each record includes the student, the advisor’s name, the date and type of session, session notes, and whether a follow-up is required. With five records covering four session types across academic and financial support contexts, this table is useful for student services queries and at-risk student reporting.