Enrollix : University Course Enrollment System

A full-stack university course management system built as a database systems project, modeled after real-world university portals. The system supports three roles : student, teacher, and admin. Each with dedicated features and dashboards.

Overview

What started as a simple course registration system grew into a complete enrollment platform covering admissions logic, attendance, grading, fee management, and semester transitions. All enforced at the database level through stored procedures and triggers.

Features

• Student enrollment with prerequisite checking, credit limit validation, fee verification, and duplicate prevention
• Waiting list with auto-promotion, when a student drops a course, the next person in line is automatically enrolled via trigger
• Section swap requests with atomic transaction handling between two students
• Attendance tracking with 80% eligibility enforcement before grades can be posted
• Grade management that moves completed records into a permanent academic history table
• Fee payment system that unlocks course enrollment
• Semester rollover that archives the current term and resets the system for the next one
• Full audit logging, every enrollment, drop, grade, and attendance change is automatically tracked via triggers
• Reporting views for GPA rankings, instructor workload, section fill rates, and student activity

Database

• 15 tables with proper constraints, foreign keys, and check constraints
• 12 stored procedures handling all business logic (enrollment validation, grade posting, attendance marking, semester rollover, etc.)
• 8 triggers for automated actions (waitlist promotion, audit logging, seat management)
• 12 views for reporting and simplified data access

Tech Stack

• Database: Microsoft SQL Server
• Backend: Node.js, Express
• Frontend: React

Team

• Komal Saeed
• Aleena Shahid
• Maseera Adnan

This was built as a group project for our database systems coursework.