This project is a relational database system designed using MySQL to manage academic data for a college environment. It demonstrates strong fundamentals of DBMS, RDBMS concepts, SQL queries, joins, subqueries, and views. 🔹 Features -Well-structured relational schema with primary & foreign keys -Real-world entities: Students, Instructors, Courses, Departments, Enrollments, Classrooms, Schedules -Data manipulation using INSERT, UPDATE, SELECT -Advanced querying using: -INNER JOIN & LEFT JOIN -GROUP BY & HAVING -Subqueries -SQL VIEW for complete student timetable reporting
🔹 Database Tables -Departments -Students -Instructors -Courses -Enrollments -Classrooms -Class Schedules
🔹 Key SQL Concepts Used -Relational Design & Normalization -Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL) -Aggregation & Filtering -Multi-table Joins -Subqueries -Views
🔹 Sample View ->student_timetable_view Provides a complete timetable including student, course, instructor, classroom, and schedule details.
🔹 Tools & Technologies -MySQL -MySQL Workbench -SQL
🔹 Future Enhancements -Backend integration using Python (Flask/FastAPI) -GUI or Web Interface -Role-based access (Admin / Student / Instructor)