Repository files navigation

This project is aStudent Management System built using MySQL. It includes database tables for managing student records, courses, enrollment, attendance, and marks.

• Store student details (name, age, class, contact).
• Manage courses and instructors.
• Track student enrollments in courses.
• Record attendance status (Present/Absent).
• Store student marks and grades.

The database consists of the following tables:

• Students: Stores student details.
• Courses: Contains course details and instructor names.
• Enrollment: Tracks which students are enrolled in which courses.
• Attendance: Records student attendance for courses.
• Marks: Stores student grades and marks.

1. Import thestudent_management.sql file into MySQL.
2. Use SQL queries to insert, update, or fetch data.
3. Modify and expand as needed for your projects.

To fetch all students:

SELECT*FROM Students;

To enroll a student in a course:

INSERT INTO Enrollment (student_id, course_id, enrollment_date)VALUES (1,2,'2025-03-29');

This project is open-source.

Awais Manzoor