University Database Management System using Microsoft SQL Server University Database Management System (DBMS)
This repository contains a University Database Management System developed using SQL on Microsoft SQL Server as part of an academic DBMS project.
The system models core university entities such as Students, Professors, Courses, and Departments, demonstrating real-world database relationships and operations.
🔸 Key Features
Well-structured relational database schema
Primary & foreign key constraints
One-to-many and many-to-many relationships
Data manipulation using INSERT, UPDATE, DELETE
Advanced queries using JOINs, subqueries, IN, NOT IN, EXISTS
Scalar and Table-Valued Functions
Stored Procedures for modular database operations
Triggers for automated actions after insert, update, and delete events
Demonstration of SQL Server–specific features
🔸 Technologies Used
Microsoft SQL Server
SQL (DDL, DML, DCL concepts)
🔸 Contributors
Muhammad Yousaf Naeem
Muzamil Altaf
🔸 Purpose
This project was developed to gain hands-on experience with database design, optimization, and backend logic implementation, following industry-relevant DBMS practices.