A complete University Management Database project designed to manage students, courses, professors, faculties, and administrative data efficiently.
Built using Microsoft SQL Server for the backend and a Python (Tkinter) GUI for user interaction.
This project simulates a university information system that handles:
- Student enrollment and academic records
- Faculty and staff management
- Course information and teaching assignments
- Data integrity and relationships through a normalized database schema
It was developed as part of a Database Systems course to apply concepts of data modeling, normalization, and SQL operations in a real-world scenario.
- Normalized relational schema with clear relationships (1–N, M–N, inheritance)
- Student and course management (enrollment, grades, GPA)
- Faculty and employee tracking (professors, administrators, workers)
- Python GUI using Tkinter for CRUD operations
- Data views and queries for insights and reporting
- Referential integrity ensured via foreign keys and constraints
- ER Diagram:
university ERD Diagram.pdf - Relational Schema:
Relational Schema.pdf
The database follows a modular design with main entities:
Person,Student,EmployeeCourse,Enrollment,Faculty,Teach
Inheritance is implemented via IS-A relationships between entities such as Employee → Professor → Administrative.
| File | Description |
|---|---|
DDL.sql |
Database creation and table definitions (DDL statements) |
insert_data.sql |
Sample dataset for testing |
data_views.sql |
Predefined SQL views for reports and analytics |
- Implemented with Python Tkinter
- Connects directly to SQL Server via ODBC
- Supports basic CRUD operations (Create, Read, Update, Delete)
- Displays data in user-friendly form fields and tables
File: GUI.py
| Layer | Technology |
|---|---|
| Database | Microsoft SQL Server |
| GUI / Application | Python, Tkinter |
| Language | SQL, Python |
| Design | ERD, Relational Schema |