niversity System is a comprehensive database-driven web application developed as part of our Database course project, aimed at managing core university operations in a structured and efficient way.
The system handles students, instructors, departments, courses, classrooms, schedules, and enrollments, with a strong focus on relational database design, data integrity, and real academic workflows.
📌 What the project includes:
Well-structured SQL Server database design
Multiple related entities with primary & foreign key constraints
Student, Instructor, Department, and Course management
Course enrollment and grading system
Classrooms and course scheduling
User login system for secure access to the web application
Clean, organized schema following database best practices
Sample data for realistic testing and validation
🛠 Technologies used:
SQL Server – T-SQL – Relational Database Design
Basic Web Interface (HTML, CSS, JavaScript)
🎯 What we gained from this project:
This project really helped us improve our understanding of database design, writing complex SQL scripts, and connecting backend logic with a simple web interface.