Computer Application Project
Python Programming with MySQL Database
West Bengal Council of Higher Secondary Education (WBCHSE)
1. Introduction
This project demonstrates how Python programming can be integrated with MySQL database to
create a simple Student Management System. The system allows users to add, view, update, and
delete student records efficiently.
2. Objectives
• To understand database connectivity using Python and MySQL. • To perform CRUD operations
(Create, Read, Update, Delete). • To design a simple real■life computer application project.
3. Software Requirements
• Python 3.x • MySQL Server • MySQL Connector for Python • Code Editor (VS Code / IDLE)
4. System Design
The system uses Python as the front■end logic and MySQL as the back■end database. A table
named students is created to store student details such as ID, Name, Class, and Marks.
5. Database Structure
Table Name: students Fields: • id (Primary Key) • name (VARCHAR) • class (VARCHAR) • marks
(INT)
6. Sample Python Code
import [Link] conn = [Link](host="localhost", user="root",
password="password", database="school") cursor = [Link]() [Link]("CREATE
TABLE students(id INT PRIMARY KEY, name VARCHAR(50), class VARCHAR(20), marks INT)")
7. Output
The program allows the user to: • Insert student data • Display records • Update marks • Delete
records
8. Advantages
• Easy data management • Fast retrieval of information • Real■life application based learning
9. Conclusion
This project shows how Python can be connected with MySQL to build useful applications. It
improves understanding of databases, programming logic, and real■world problem solving.