The Student Management System is a comprehensive and relational database model designed to streamline academic record keeping within an educational institution. Built using MySQL, this system efficiently manages information related to students, departments, courses, enrollments, and instructors.

This project is ideal for learning database normalization, SQL queries, and understanding real-world entity relationships within a college environment.

Below is the ER Diagram representing the structure and relationships of the College Database.

• 🔗 Relational Schema Design: Fully normalized database structure using primary and foreign key constraints.
• 🧱 Five Well-Structured Tables: Students, Departments, Courses, Enrollments, and Instructors.
• 🔄 Many-to-Many Relationship: Managed using an intermediate table Enrollments for tracking course registrations.
• 📊 Support for Analytical Queries: Includes logic for performance tracking, course popularity, and student distribution.
• 🔍 Data Integrity Enforcement: Ensures consistency across entities with well-defined constraints.
• 📁 Schema Visualization Included: Understand the architecture clearly through an embedded ER diagram.

• Students: Basic info + academic department association
• Departments: List of college departments
• Courses: Offered courses linked to departments
• Enrollments: Junction table connecting students and courses with timestamps
• Instructors: Faculty members assigned to departments

• SQL (MySQL / MariaDB)
• Draw.io for schema design
• PDF documentation for quick reference

Full technical documentation is available in PDF format, detailing:

• Schema design and logic
• Table relationships
• SQL query logic for analytical use cases

• Academic Record Management Systems
• SQL Learning & Query Practice
• ERD Design Training
• Student Enrollment Prototypes

Developed with focus on academic structure, data clarity, and real-world mapping of educational institutions.