INTRODUCTION
The project deals with calculation of house points during school
youth festival. This also helps in sorting student details along with
keeping a record of the event they participated.
Data can be entered according to the Event coordinator's interest
and the system is set very simple so that the records could be easily
understood by the viewer. Data can be easily modified and deleted
according to the Event coordinator's need. A well arranged record of
students, events and house points can be kept and viewed whenever
needed. This makes it easier for the school to distribute various
prizes for the students and calculate the points of houses without
any errors.
SURVEY OF TECHNOLOGIES
The following software are used in the project for the development of SCHOOL
YOUTH FESTIVAL
1. PYTHON: Python is an interpreter, high-level, general-purpose programming
language developed by Guido van Rossum in 1991. Python is dynamically typed
and garbage-collected. It supports multiple programming paradigms, including
procedural, object-oriented, and functional programming. Python is often
described as a "Batteries Included" language due to its comprehensive
standard library.
There are two major Python versions - Python 2 and Python 3. The version
used for this project is PYTHON 3.8.
2. MY SQL: My SQL is an open-source relational database management system
(RDBMS). My SQL is free and open-source software under the terms of the
GNU General Public License. It is the world's most popular open source
database. With its proven performance, reliability, and ease-of-use, My SQL
has become the leading database choice for web-based applications, used by
high profile web properties including Face book, Twitter, YouTube etc.
[Link] SQL-Connector-Python: Python needs a My SQL driver to access the My
SQL database. This is a driver "My SQL Connector" used to connect python and
Mysql databases. We can install this connector using PIP command, pip install
mysql-connector-python.
SOFTWARE & HARDWARE
REQUIREMENTS
HARDWARE SPECIFICATIONS:
➤ PROCESSOR : PENTIUM DUAL CORE or Above
➤ RAM : 2 GB
➤HARD DISK : 500 GB
➤ MONITOR : 14" LED or Above
➤ KEYBOARD : 104 KEYS
➤ MOUSE : OPTICAL MOUSE
➤ PRINTER : 24 Pin DOTMATRIX or above
SOFTWARE SPECIFICATIONS:
➤ OPERATING SYSTEM : WINDOWS 7 or Above
➤ FRONT END : Python 3 or Above
➤ MIDDLEWARE : Python-MySQL Connector
➤ BACKEND : MySQL
EXTERNAL MODULES IMPORTED
⚫ import [Link]
connect(), cursor(), fetchone(), fetchall(),execute(), commit()
⚫ from prettytable import Pretty Table
Pretty Table(), add_row()
⚫ import time
sleep()
⚫ from os import system
system()
CONCLUSION
We have much delighted and relieved with the successful completion of our
project. We have made a small attempt in developing a computer based
solution for SCHOOL YOUTH FESTIVAL. This project helped us immensely in
understanding the basic principles behind the operations involved within
Python- My SQL project environment.
We tested SCHOOL YOUTH FESTIVAL and are found to be working satisfactorily
and no serious errors are spotted. Hence this software project has been
developed to fulfill the academic learning in CBSE Class XII, computer science
curriculum.
BIBLIOGRAPHY
1. [Link]
2. [Link]
3. [Link]
4. Computer Science with Python (XI)
5. Computer Science with Python (XII)
DESIGN AND IMPLEMENTATION
This program is developed in the most widely used programming language
Python. The source is simple and is made user friendly with sufficient number
of messages for the user to understand.
The functions used are
> mainmenu()
This function is used to display the Main menu of the program
➤ Insert()
This function is used to insert details of students and house points will be
updated automatically
➤ Modify()
This function is used to modify student details selected from the sub menu
which includes modifying name class house event and position.
➤ Delete()
This function is used to delete records of a student based on there admission
number
> Point()
This function is used to display the all houses and points
➤ Display()
This function is used to display the entire students details