This project is designed to simulate a real college management database using SQL. It manages data for students, teachers, courses, enrollments, and marks, making it an excellent practice for DBMS and Data Analyst aspirants.
- Database: PostgreSQL / MySQL
- Tool: pgAdmin / MySQL Workbench
- Language: SQL (DDL, DML, Joins, Aggregations)
| Table | Description |
|---|---|
students |
Stores student personal details |
teachers |
Contains teacher and department info |
courses |
Course and assigned teacher data |
enrollments |
Links students with enrolled courses |
marks |
Records marks and exam details |
- Helps visualize student performance per department
- Shows course–teacher–student relationship
- Forms the base for academic analytics dashboards
📁 College_Database_System_Project/
- ┣ 📄 schema.sql → Database Design
- ┣ 📄 data.sql → Sample Data
- ┣ 📄 queries.sql → Analytical SQL Queries
- ┗ 📄 README.md → Project Description
Kuldeep Sharma Assistant Professor | Data Analyst Aspirant 📍 India