SCHOOL MANAGEMENT SYSTEM

A Database Management System Project

Name: ALVIN ROBINSON

Class: XII-B

Subject: Computer Science

Adm no-10576

Academic Year: 2025-26

CERTIFICATE
This is to certify that the project
entitled “School Management System”
has been successfully completed by
ALVIN ROBINSON of class XII-B in
partial fulfillment of the requirement
for Computer Science project as
prescribed by Mrs. Charu during the
academic year 2025-26.

Internal External
Examiner Examiner
ACKNOWLEDGMENT
I would like to express my heartfelt
gratitude to my Computer Science
teacher Mrs. Charu for the invaluable
guidance and support throughout the
course of this project. I would also like
to thank my school and my family for
encouraging me to complete this
project successfully.
 CONTENTS
• About SQL
• About Python
• Introduction
• Objective
• Software Used
• Hardware Used
• Database Tables
• Table Data
• Python Code
• Main Screen
• Main Menu
• Conclusion
• User defined modules and their modules
• Bibliography
 ABOUT SQL
SQL (Structured Query Language) is a standardized language
used to manage and manipulate relational databases. It allows
you to:
• Store and organize data in tables
• Update, delete, and insert records
• Create and manage databases, tables, and permissions
Key SQL Commands:
1. DDL (Data Definition Language):
o CREATE: Create tables/databases
o ALTER: Modify table structure
o DROP: Delete tables/databases
2. DML (Data Manipulation Language):
o SELECT: Retrieve data
o INSERT: Add new records
o UPDATE: Modify existing records
o DELETE: Remove records
 ABOUT PYHTON
Python is a high-level, interpreted, general-purpose
programming language known for its simple syntax and
readability. It was created by Guido van Rossum and
first released in 1991.
Key Features of Python
• Easy to Learn – Python has a clean and readable
syntax.
• Interpreted – No need to compile, just run the
script.
• Dynamically Typed – No need to declare variable
types.
• Extensive Libraries – Libraries for web, data
science, automation, etc.
• Object-Oriented & Functional – Supports
multiple programming paradigms.
• Cross-Platform – Runs on Windows, Mac, Linux,
etc.
 Introduction
The School Management System
project is designed to streamline the
administrative tasks involved in
managing student and teacher and
managing inventory, fees, library
books, subjects and much more using
SQL for database management and
Python for backend logic.
 Objective
The objective of this project is to let the students
apply the programming knowledge into a real-
world situation and get the students exposed to
how programming skills helps in developing a
good software.
❖Write programs utilizing modern software
tools.
❖ Apply object-oriented programming
principles effectively when developing small
to medium sized projects
❖ Write effective procedural code to solve small
to medium sized problems.
❖Students will demonstrate ability to conduct
research or applied Computer Science project,
requiring writing and presentation skills .
 Software Used

• Python 3.12.3
• MySQL
• MS Word (for documentation)
 Hardware Used

Operating system: windows 11

Processor : Intel core i5 12th gen
RAM : 16GB
Keyboard : Available
Mouse : Available
Database Tables
Tables:

- Student:

- Teacher:
- Classes:

- Subjects:

- Fees:
- Library:

- Inventory:
Table data
- Student:

- Teacher:

- Classes:
- Subjects:

- Fees:
-Library:

- Inventory:
Python Code
MAIN SCREEN
MAIN MENU
Add New Student:

Add New Teacher:

Add class:
Add Subject:

Add Book:
Add inventory:

Add Fee details:

Remove Student:

Remove Teacher:
Display Teachers:

Display Students:
Exit:
User defined modules and
their uses
1. Student Module
o Add new student records
o Remove student records
o Display all students
2. Teacher Module
o Add new teacher records
o Remove teacher records
o Display all teachers
3. Class Module
o Add new class details (class name, section, etc.)
4. Subject Module
o Add new subjects offered in the school
5. Fee Module
o Add fee details for students
o Keep track of payments
6. Library Module
o Add new books to the library database
o Manage library records
7. Inventory Module
o Add inventory items (e.g., lab equipment,
furniture, etc.)
o Keep stock records
8. Menu / Main Screen Module
o Provides the interface to choose between
different options (Add Student, Add Teacher,
Add Book, etc.)
o Acts as the control centre connecting all module
Conclusion
The School Management System
successfully demonstrates how
databases and programming can be
integrated to manage real-world
scenarios. This project enhanced my
knowledge of Python and SQL
integration.
Bibliography
• https://www.w3schools.com
• www.scribd.com
• www.google.com
• Class notes and textbooks