📘 Student Records Management System
📌 Objective
The purpose of this project is to design and implement a relational database in MySQL that manages student academic records. It demonstrates the use of tables, constraints, and relationships (One-to-Many, Many-to-Many) in a real-world scenario.
🛠️ Features
- Manage students and their personal details.
- Manage lecturers and their departments.
- Manage courses offered by the institution.
- Track enrollments of students into courses (Many-to-Many relationship).
- Record grades for each student’s course enrollment.
📂 Database Schema
The database consists of the following tables:
- Students – Stores student details.
- Lecturers – Stores lecturer details.
- Courses – Stores course details and links to lecturers.
- Enrollments – Junction table linking students and courses (Many-to-Many).
- Grades – Stores grades linked to enrollments.
SOURCE student_records.sql;