📘 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:

1. Students – Stores student details.
2. Lecturers – Stores lecturer details.
3. Courses – Stores course details and links to lecturers.
4. Enrollments – Junction table linking students and courses (Many-to-Many).
5. Grades – Stores grades linked to enrollments.

---

---

SOURCE student_records.sql;