Scribd
Upload
35 views3 pages

MySQL Student Management System Report

The Student Management System project report outlines a MySQL-based system for managing student data, course enrollments, assessments, and attendance. It includes functional requirements, an ER diagram, a relational schema in 3NF, and SQL code for creating tables and querying data. The project demonstrates effective database design and provides practical experience in handling academic management data.

Uploaded by

akashnaredla123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
35 views3 pages

MySQL Student Management System Report

The Student Management System project report outlines a MySQL-based system for managing student data, course enrollments, assessments, and attendance. It includes functional requirements, an ER diagram, a relational schema in 3NF, and SQL code for creating tables and querying data. The project demonstrates effective database design and provides practical experience in handling academic management data.

Uploaded by

akashnaredla123
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Student Management System – DBMS Project Report

1. Introduction
This project is a Student Management System built using MySQL. It handles core student
data, course enrollments, assessments, and attendance. The system allows retrieval and
analysis of academic performance and provides support for administrative queries and
reports.

2. Functional Requirements
- Add and retrieve student information
- Track course enrollments and academic performance
- Maintain department, course, and faculty data
- Record assessments and attendance
- Support SQL queries for reports (e.g., grade sheets, attendance summaries)

3. ER Diagram
The ER diagram below represents the structure of the Student Management System:

4. Relational Schema (3NF)

Student(StudentID, Name, Gender, DateOfBirth, Address, Email, Phone, AdmissionYear,


CurrentSemester, Program, DepartmentID)
Department(DepartmentID, DepartmentName, HeadOfDepartment)
Faculty(FacultyID, Name, Email, Phone, Designation, DepartmentID)
Course(CourseCode, CourseName, Credits, SemesterOffered, DepartmentID, FacultyID)
Enrollment(EnrollmentID, StudentID, CourseCode, AcademicYear, Semester, Grade, Status)
Assessment(AssessmentID, CourseCode, ComponentName, MaxMarks)
Marks(StudentID, AssessmentID, ObtainedMarks)
Attendance(AttendanceID, StudentID, CourseCode, Date, PresentAbsent, TotalClassesHeld,
TotalClassesAttended)

5. SQL Code Summary


Create Tables:

All tables include Primary Keys, Foreign Keys with constraints (e.g., NOT NULL, UNIQUE,
CHECK).

Insert Sample Records:


- 2 Departments
- 2 Students
- 2 Faculty
- 2 Courses
- 2 Enrollments
- 4 Assessments
- 4 Marks
- 2 Attendance Records

Select Queries:
- List students by department
- Grade sheet of a student
- Attendance summary for a course
- Top 3 performers in a subject

6. Sample Query Outputs


Grade Sheet: Shows the student name, course, and grade

Attendance Summary: Shows total classes attended vs held

Top Performers: Lists top 3 students by marks in a specific course

(Include screenshots or query result outputs here.)

7. Conclusion
This project demonstrates how to design a normalized relational database system for
academic management. The system was implemented using MySQL, covering ER design,
normalization, SQL scripting, and reporting.
It provides hands-on experience with relational schema design, constraints, foreign key
relationships, and SQL queries for real-world data handling.

You might also like