A
Micro Project Report On
Advanced Student Record Management
System Using MySQL
Submitted by
1 .[Link]
[Link] .[Link]
[Link]
Under the Guidance of
([Link])
In the Partial Fulfillment of Third Semester of Diploma in
Information Technology
JSPM’s
JAYAWANTRAOSAWANTPOLYTECHNIC,
Handewadi Road, Hadapsar, Pune-28
Department of Information
Technology Affiliated to
Maharashtra State
Board of Technical Education Academic Year2025-26
Maharashtra State
Board of Technical Education
Certificate
is is certify that Mr. [Link] with Roll Roll:34 has Successfully
completedMicro-project in course DATABASE MANAGEMENT
SYSTEM(312302)for the academic year 2025-26 Microproject is completing Third
Semester of Diploma in Information Technology frominstitute, Jayawantrao Sawant
Polytechnic withInstitute code 0711.
Plase:Hadapsar Enrollment No : 24211830898
Date: Exam Seat No:
Course Teacher Head of the Department. Head of the institute
Maharashtra State
Board of Technical Education
Certificate
This is to certify that [Link] . With Roll no:27 has successfully
completed Micro-project DATABASE MANAGEMENT SYSTEM
(313302) for the academic year 2025-26 Micro project is completing Third Semester
of Diploma in Information Technology from institute, Jayawantrao Sawant
Polytechnic with institute code 0711.
Place: Hadapsar. Enrollment no: 24211830890
Date: Exam Seat No:
Course Teacher Head of the Department Head of the Institute
Maharashtra State
Board of Technical Education
Certificate
This is to certify that [Link] with Roll No-38 has successfully
completed Micro-project DATABASEMANAGEMENTSYSTEM(313302)
for the academic year 2025-26 Micro project is completing Third Semester of
Diploma in Information Technology from institute, Jayawantrao Sawant
Polytechnic with institute code 0711.
Place: Hadapsar. Enrollment no: 24211830902
Date: Exam Seat No:
Course Teacher Head of the Department Head of the Institute
INDEX
[Link] CONTENTS
1 Brief Description (Introduction)
2. AIM of Micro Project
3. Course Outcomes
4. Actual Procedure Followed
5. My SQL Code With Output
6. Conclusion
Name:
Introduction:
The Advanced Student Record Management System (ASRMS) is a
Simple database-driven application that maintains student information such as Roll
Number, Name, Department, and Marks. It demonstrates fundamental database operations
Including creation, insertion, updating, deletion, and querying records using MySQL. This
Project highlights how structured query language (SQL) and database systems are used to
Manage real-world data efficiently and [Link].
Name:
Aim of Project :
The aim of this micro-project is to develop a small-scale DBMS
Project using MySQL to store and manage student academic data. The proposed system
Allows users to:Create and manage a student table,
Insert new student records,
Update student marks,
Delete unwanted records,
Search or display specific information (e.g., toppers or students scoring above a
Threshold) This system can be expanded further in real-world scenarios like student
Portals, result management systems, or academic dashboards.
Name:
Course Outcome :
This project integrates the following course outcomes:
Understanding and application of Relational Database Management Systems (RDBMS),
Ability to design and implement databases using SQL,
Perform CRUD operations (Create, Read, Update, Delete),
Use of MySQL as a back-end database tool,
Exposure to basic database concepts such as keys, constraints n queries
Name:
Actual Procedure Followed:
Step-by-step procedure followed during the project:
Installed and set up MySQL Server and MySQL Workbench,
Created a new database: StudentDB,
Created a table: Students with fields Roll_No, Name, Department, and
Marks, Inserted multiple records into the Students table,
Performed SELECT queries to view records,
Updated the marks of a student based on roll number,
Deleted a record for demonstration purposes,
Queried the student with highest marks (topper),
Listed all students with marks greater than 80,
Verified results for correctness and documented SQL scripts,
Name:
MySQL Code
CREATE DATABASE CollegeDB;
USE CollegeDB;
CREATE TABLE StudentInfo (
StudentID INT PRIMARY KEY,
FullName VARCHAR(100),
Course VARCHAR(50),
Marks INT,
AttendancePercent DECIMAL(5,2)
);
INSERT INTO StudentInfo(StudentID ,Full Name ,Course,marks,
AttendancePercent) VALUES
(1, ‘Aarav Mehta’, ‘Computer Science’, 85, 92.50),
(2, ‘Riya Sharma’, ‘Electronics’, 91, 88.00),
(3, ‘Kabir Khan’, ‘Mechanical’, 78, 79.75),
(4, ‘Ananya Jain’, ‘Information Tech’, 88, 95.20),
(5, ‘Dev Patel’, ‘Electrical’, 82, 84.10);
SELECT * FROM StudentInfo;
UPDATE StudentInfo
Name:
SET Marks = 94
WHERE StudentID = 2;
DELETE FROM StudentInfo
WHERE StudentID = 3;
SELECT FullName, MAX(Marks) AS HighestMarks FROM StudentInfo;
SELECT * FROM StudentInfo WHERE Marks > 80;
SELECT * FROM StudentInfo ORDER BY AttendancePercent DESC;
SELECT COUNT(*) AS TotalStudents FROM StudentInfo;
Name:
OUTPUT:
Name:
CONCLUSION
This project successfully demonstrates the development of a Student Record
Management
System using MySQL. It includes essential database operations like creating tables,
Inserting, updating, deleting, and retrieving data. Additional features such as attendance
Tracking and sorting enhance its practical use. Through this project, we applied key
DBMS
Concepts and showcased how MySQL can efficiently manage structured student data.
The
System is simple, extendable, and useful for academic institutions to organize and
analyze
Student information effectively.
Software Used : MySQL WorkBench 8.0 CE
Name:
JSPM’s
JAYAWANTRAO SAWANT POLYTECHNIC,
Handewadi Road, Hadapsar, Pune-28
Department of Information Technology
Academic Year 2025-26
Teacher Evaluation Sheet
Name of student: Omar Zafar Shaikh
Enrollment No: 24211830898
Semester: Third
Course Title: DMS-Database Management System(313302)
Title of Micro Project: Student Record Management System Using MySQL
Course Outcomes Achieved:
Valuation as per suggested Rubric for Assessment of Micro Project
[Link] Characteristics Poor Average Good Exillent
to be based (Marks 1-3) (Marks 4-5) (Marks 6-8) (Marks 9-
10)
1 Relevance to
the
course
2 Literature
Survey /
Information
collection
Name:
3 Project
Proposal
4 Completion of
the
Target
as per Project
Proposal
5 Analysis of
data and
representation
6 Quality of
Prototype/
Model
7 Report
preparation
8 Presentation
9 Defense
Micro Project Evaluation Sheet
Process Product Total Marks
Assessment Assessment 10
Part A – Project Part B – Project Individual
Project Methodol Report/ Presentat
Proposa Ogy (2 working Ion/ Viva
L Marks) Model (4 Marks)
Name:
(2 Marks) (2 Marks)
Product
Assessment
Total
Marks
10
Note: Every course teacher is expected to assign marks for group evaluation in first
3 columns and individual evaluation 4th column
Comment/suggestion about teamwork/leadership/interpersonal communication (If
any)
………………………………………………………………………………………………
…
………………………………………………………………………………………………
…
Any other comment:
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
Name and Designation of the Faculty Member:
Signature:
Name:
JSPM’s
JAYAWANTRAO SAWANT POLYTECHNIC,
Handewadi Road, Hadapsar, Pune-28
Department of Information Technology
Academic Year 2025-26
Teacher Evaluation Sheet
Name of student: Rajveer Moresh Sahare
Enrollment No: 24211830890
Semester: Third
Course Title: DMS-Database Management System(313302)
Title of Micro Project: Student Record Management System Using MySQL
Course Outcomes Achieved:
Valuation as per suggested Rubric for Assessment of Micro Project
[Link] Characteristics to Poor(Marks 1- Average Good Exillent
be based 3) (Marks 4- (Marks 6- (Marks 9-
5) 8) 10)
1 Relevance to the
Course
2 Literature Survey /
Information
Name:
Collection
3 Project Proposal
4 Completion of the
Target
As per Project
Proposal
5 Analysis of data and
Representation
6 Quality of
Prototype/
Model
7 Report preparation
8 Presentation
9 Defense
Name:
Micro Project Evaluation Sheet
Process Product Total Marks
Assessment Assessment 10
Part A – Project Part B – Project Individual
Project Methodol Report/ Presentat
Proposa Ogy (2 working Ion/ Viva
L (2 Marks) Marks) Model (4 Marks)
(2 Marks)
Product
Assessment
Total
Marks
10
Name:
Note: Every course teacher is expected to assign marks for group evaluation in first
columns and individual evaluation 4th column
Comment/suggestion about teamwork/leadership/interpersonal communication (If
any)
………………………………………………………………………………………………
… ………………………………………………………………………………………………
…
Any other comment:
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
Name and Designation of the Faculty Member:
Signature:
Name:
JSPM’s
JAYAWANTRAO SAWANT POLYTECHNIC,
Handewadi Road, Hadapsar, Pune-28
Department of Information Technology
Academic Year 2025-26
Teacher Evaluation Sheet
Name of student: Swaraj Rohidas Mhaske
Enrollment No:24211830902
Semester: Third
Course Title: DMS-Database Management System(313302)
Title of Micro Project: Student Record Management System Using MySQL
Course Outcomes Achieved:
Valuation as per suggested Rubric for Assessment of Micro Project
[Link] Characteristics to Poor(Marks 1- Average Good Exillent
be based 3) (Marks 4- (Marks (Marks 9-
5) 6-8) 10)
Name:
1 Relevance to the
Course
2 Literature Survey /
Information
Collection
3 Project Proposal
4 Completion of the
Target
As per Project
Prop
5 Analysis of data
and
Representation
6 Quality of
Prototype/
Model
7 Report preparation
Name:
8 Presentation
9 Defense
Name:
Micro Project Evaluation Sheet
Process Product Total Marks
Assessment Assessment 10
Part A – Project Part B – Individual
Project Methodol Project Presentat
Proposa Ogy (2 Report/ Ion/ Viva
L (2 Marks) Marks) working (4 Marks)
Model
(2 Marks)
Product
Assessment
Total
Marks
10
Name:
Note: Every course teacher is expected to assign marks for group evaluation in first
Columns and individual evaluation 4th column
Comment/suggestion about teamwork/leadership/interpersonal communication (If
any)
………………………………………………………………………………………………
… ………………………………………………………………………………………………
…
Any other comment:
………………………………………………………………………………………………
………………………………………………………………………………………………
………………………………………………………………………………………………
Name and Designation of the Faculty Member:
Signature: