COMPUTER SCIENCE PROJECT
Project Title: Student Management System using Python & SQL
Submitted for Practical Examination (Class XII)
Submitted by: ____________________
Class & Section: XII
Session: 2025–26
School: ____________________
Submitted to: ____________________
CERTIFICATE
This is to certify that the project titled “Student Management System using Python & SQL” is an
original work carried out by the student under my supervision and fulfills the requirements of the Class XII
Computer Science practical examination.
Teacher’s Signature: ____________
Date: ____________
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my Computer Science teacher for guidance and support. I
also thank my school and my parents for providing the resources and encouragement to complete this
project successfully.
1. INTRODUCTION
This project is based on the concepts learned in Classes XI and XII Computer Science. The Student
Management System helps in storing, retrieving, and managing student records efficiently using Python
and SQL.
2. OBJECTIVES
• To apply Python programming concepts in real-life problems.
• To use SQL for storing and managing data.
• To understand Python–SQL connectivity.
3. TOOLS & TECHNOLOGIES USED
• Programming Language: Python
• Database: MySQL
• Connector: mysql-connector-python
4. SYSTEM REQUIREMENTS
• Operating System: Windows/Linux
• Python 3.x installed
• MySQL Server
5. DATABASE DESIGN
Field Name Data Type Description
Roll_No INT Student Roll Number
Name VARCHAR(50) Student Name
Class VARCHAR(10) Class of Student
Marks INT Marks Obtained
6. PYTHON–SQL CONNECTIVITY
Python is connected to MySQL using the mysql-connector module. This allows execution of SQL queries
directly from Python programs for data insertion, deletion, and retrieval.
7. FEATURES OF THE PROJECT
• Add new student records
• Display all records
• Update student marks
• Delete student records
8. CONCLUSION
This project helped me understand the practical implementation of Python and SQL concepts. It
enhanced my programming skills and database handling knowledge.
9. BIBLIOGRAPHY
• NCERT Computer Science Textbook
• Python Documentation
• MySQL Documentation