DELHI JAIN
PUBLIC
SCHOOL
[SCHOOL ACADEMIA]
COMPUTER
SCIENCE PROJECT
FILE
SUBMITTED BY- Arjav jain
CLASS- XII- A1
ROLL NO.-
S.NO. CONTENT
1 ACKNOWLEDGEMENT
2 CERTIFICATE
3 PYTHON MODULES AND
Functions USED I N PROGRAM
4 Hardware specification and
software specification
5 Project front end and back end
6 introduction
7 objective
8 Program description
9 Flow chart
10 Coding
11 Output
12 My sql
13 bibliography
CONTENTS
ACKNOWLEDGEMENT
This is my duty to record my sincere and deep sense of
gratitude to my respected teacher, Ms. PRIYANKA
BISHT for her valuable guidance, interest and constant
encouragement for fulfilment of this project file.
I am also highly obliged to our other Computer teacher
who provided me the necessary guidance. I would also
like to thank my family for encouraging me during the
course of this project.
Finally I would like to thank CBSE for giving me this
opportunity to undertake this project.
CERTIFICATE
This is to certify that “ ARJAV JAIN’ ’’ of class XII A1, Delhi
Jain Public School, New Delhi has successfully completed
his project “SCHOOL ACADEMIA ” under my supervision in
computer practical’s for the AISSCE as prescribed by CBSE
in the year 2021-2022.
Date: Roll No. :
PRINCIPAL ‘S TEACHER ‘S
SIGNATURE SIGNATURE
PYTHON MODULES AND
FU NCTI O·N USED IN
PROGRAM
MODULES :
pickle Module : Used for serializing and
deserializing a python object structure.
My SQL . connector : Used for
connecting mysql database with python.
FUNCTIONS :
• open() : To open a file .
• close() : To close a file.
• pickle.load() : To read a binary file.
• pickle.dump : To write into a binary file.
• Try and except clause: To handle error in
python program.
• Cursor() : enables the sequential processing of
rows in a result set.
• Execute(): for executing the query.
Hardware specification and software
specification
HARDWARE REQUIRED
Printer to print the required documents
Compact Drive
Processor : Intel Core i5
Ram : 4 GB
Hard disk: 500 GB.
SOFTWARE REQUIRED
1. Operating system : Windows 7 64-bit
2. Code: python interpreter for execution of program
3. Microsoft word for presentation of output.
4. Python version : 3.7.9 or higher
Project front end and back end
1. (FRONT END)
2. (BACK END)
SCHOOL Academia project is developed
using python as Front End and mysql as
Back End.
introduction
The "School Management System" has been developed to
override the problems prevailing in the practicing manual
system. This software is supported to eliminate and in
some cases reduce the hardships faced by this existing
system. Moreover this system is designed for the particular
need of the company to carry out operations in a smooth
and effective manner. The application is reduced as much
as possible to avoid errors while entering the data. It also
provides error message while entering invalid data. No
formal knowledge is needed for the user to use this system.
Thus by this all it proves it is user-friendly. School
Management System , as described above, can lead to error
free, secure, reliable and fast management system. It can
assist the user to concentrate on their other activities
rather to concentrate on the record keeping. Thus it will
help organization in better utilization of resources.
Objective
The main objective of the Python Project on
School Management System is to manage the
details of Teachers, Courses, Classes,
Students, and Registrations. It manages all
the information about Teachers, Schools,
Registrations, and Teachers. The project is
totally built at administrative end and thus only
the administrator is guaranteed the access. The
purpose of the project is to build an application
program to reduce the manual work for managing
the Schools, Students, Registrations, Classes . It
tracks all the details about the Classes, Teachers,
Courses.
Program description
Flow chart
2. Commande 3. As the python
d Program and My SQL are
will be connected. The
executed in command will
Python be sent to My
Idle. SQL.
1. Then the
4. The required
data will be
data will be
sent to the
taken from the
Python Idle.
database.
Coding
My sql
My SQL is a database management system that is
used to maintain relational databases. It is an
open-source software backed by Oracle
Corporation. This was originally founded by a
Swedish company called MYSQL AB which was
later acquired by sun micro-systems and finally is
with Oracle Corporation. As it is an open-source
database system, the source code can be
modified according to our needs. It also offers
premium services if a commercial license is
purchased from Oracle Corporation. MyS QL is a
scalable, fast, and reliable database management
system which can run on any platform like
Windows, Unix, Linux, etc., and can be installed
on the desktop or any server machine. It is also
very to master compared to other database
management systems existing in the market like
Microsoft SQL Server, Oracle Database, etc. My
SQL is most suitable for web applications.
BIBLIOGRAPHY
www.icbse.nic.in
Computer Science By Sumita Arora
www.cbseportal.com
