Scribd
Upload
23 views8 pages

Student Management System With Source Code

The document certifies that Deependra Nath Pandey completed a project titled 'Student Management System' using Python and MySQL. It includes sections on the project's introduction, objectives, tools, database design, source code, advantages, future scope, conclusion, and bibliography. The project aims to efficiently manage student records and demonstrates the integration of Python with MySQL.

Uploaded by

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

Student Management System With Source Code

The document certifies that Deependra Nath Pandey completed a project titled 'Student Management System' using Python and MySQL. It includes sections on the project's introduction, objectives, tools, database design, source code, advantages, future scope, conclusion, and bibliography. The project aims to efficiently manage student records and demonstrates the integration of Python with MySQL.

Uploaded by

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

CERTIFICATE

This is to certify that Deependra Nath Pandey, student of Class XII, has successfully completed
the project titled Student Management System using Python and MySQL as a part of the
Computer Science curriculum. This project is an original work.

Teacher’s Signature: ____________________

Date: ____________________
ACKNOWLEDGEMENT

I would like to thank my Computer Science teacher for guidance and support. I am also grateful to
my school for providing necessary facilities, and to my parents and friends for their encouragement.
INDEX

[Link] Content Page No


1 Certificate 1
2 Acknowledgement 2
3 Introduction 4
4 Objective 4
5 Tools & Technologies 5
6 Database Design 6
7 Source Code 7
8 Advantages 9
9 Future Scope 9
10 Conclusion 10
11 Bibliography 11
Student Management System using Python and
MySQL

1. Introduction

This project is developed using Python and MySQL to manage student records efficiently.

2. Objective

To integrate Python with MySQL and perform database operations.

3. Tools & Technologies

Python Programming Language


MySQL Database
mysql-connector-python Database Connectivity

4. Database Design

Database: student_db

Table: students (roll_no, name, class, section, marks)


SOURCE CODE

import [Link]

db = [Link](
host="localhost",
user="root",
password="your_password",
database="student_db"
)

cursor = [Link]()

def insert_student():
r = int(input("Roll No: "))
n = input("Name: ")
c = input("Class: ")
s = input("Section: ")
m = int(input("Marks: "))
[Link](
"INSERT INTO students VALUES (%s,%s,%s,%s,%s)",
(r,n,c,s,m)
)
[Link]()

def show_students():
[Link]("SELECT * FROM students")
for row in [Link]():
print(row)

def update_marks():
r = int(input("Roll No: "))
m = int(input("New Marks: "))
[Link](
"UPDATE students SET marks=%s WHERE roll_no=%s",
(m,r)
)
[Link]()

def delete_student():
r = int(input("Roll No: "))
[Link]("DELETE FROM students WHERE roll_no=%s", (r,))
[Link]()

while True:
print("[Link] [Link] [Link] [Link] [Link]")
ch = int(input("Enter choice: "))
if ch == 1:
insert_student()
elif ch == 2:
show_students()
elif ch == 3:
update_marks()
elif ch == 4:
delete_student()
elif ch == 5:
break
Advantages

• Easy to use

• Secure data storage

• Fast retrieval

Future Scope

• GUI using Tkinter

• Login system

Conclusion

This project demonstrates effective use of Python with MySQL.


BIBLIOGRAPHY

1. NCERT Computer Science Textbook

2. [Link]

3. [Link]

You might also like