IP Project (Sports Mangement) Class 12 CBSE

IP Project (Sports Mangement) Class 12 CBSE

1. MES INDIAN SCHOOL

DOHA-QATAR

INFORMATICS PRACTICES
PROJECT

(2023-24)

292

Submitted By:

Under The Guidance Of:

2. AFIDE CERTIFICATE

Certified to be the bonafide record of the work done by

MasterMiss
ofclass XUXII inthe laboratory of MES. Indian

‘School, Doha-Qatar during the academic year He/she

has performed... experiments and, activities /projects.

Signature of Teacher in Charge
Name:

Date :

School Seal

Roll Number / Registration Number

LL]

Submitted for All India Senior School Certificate Practical Examination in
held at MES. Indian School

Doha-Qatar on ….

Examiner (External) Examiner (Internal)
Signature: Signature:
Name Name

Designation: ...

Desianation:

3. | undertook this Project work, as the part of our XII-
Informatics Practices course. We had tried to apply our best of

knowledge and experience, gained during the study and class

work experience. However, developing software system is

generally a quite complex and time-consuming process. It
requires a systematic study,insight vision and professional
approach during the design and development. Moreover,
the developer always feels the need, the help and good wishes
of the people near you, who have considerable experience and
idea. We would like to extend our sincere thanks and
gratitude to our teacher MRS.SAMEERA We are very much
thankful to our Principal MRS HAMEEDA KADAR and
our Head of Section MR. MOHAMMED ILIAS for his co
ordination in extending every possible support.

We would like to take the opportunity to extend our sincere
thanks and gratitude to our parents for being a source of
inspiration and providing time and freedom to develop this

software project

4. Content

Introduction.

Theoretical Background

About Python

System Implementation,

Coding

Python Output

MySQL Tables.

Limitations.

Conclusions

Bibliography.

5. = This software, being simple in design and working,

- The Olympic Games is an important international event featuring
summer and winter sports. Summer Olympic Games and Winter
Olympic Games are held every four years. Originally, the ancient
Olympic Games were held in Ancient Greece at Olympia. The Olympic
symbol consists of five interlaced rings of equal dimensions, used alone,
in one or in five different colours, which are, from left to right, blue,

yellow, black, green and red

= The following project has been designed with a deep insight into the
sports management. Some of the silent features are: -

= The following project can be used to all the activities like to add players,
equipment, winners , prizes etc.

-During coding and design of the software Project, Python, a powerful

platform and coding simplicity. As a back end a powerful, opensource
RDBMS, My SQL is used as per requirement of the CBSE curri
Informatics Practices Course.

6. - A database is a collection of information related to a particular

subject or purpose, such as tracking customer orders or maintaining a

product collection. Using any RDBMS application software like

MS SQL Server, MySQL, Oracle, Sybase ete, you can manage

all your information from a single database file. Within the fe,

divide your data into separate storage containers called tables.
and retrieve the data using queries,

-A table is a collection of data about a specific topic, such as
products or suppliers. Using a separate table for each topic means you
can store that data only once, which makes your database more
efficient and reduces data-entry errors. Table organises data into

columns (called fields) and rows (called records)
=A Primary key is one or more fields whose value or values
uniquely identify each record in a table. In a relationship, a primary

key is used to refer to specific record in one table from another table

-A primary key is called foreign key when itis referred to from

another tabl

-To find and retrieve just the data that meets conditions you

specify including data from multiple tables, create a query. A query

perform built-in or custom calculations on your data

7. data into separate storage containers called tables. You may
and retrieve the data using queries.

=A table is a collection of data about a specific topic, such as
products or suppliers. Using a separate table for each topic means you
can store that data only once, which makes your database more
efficient and reduces data-entry errors. Table organises data into
columns (called fields) and rows (called records).

=A Primary key is one or more fields whose value or values

uniquely identify each record ina table. In a relationship, a primary
key is used to refer to specific record in one table from another table

= A primary key is called foreign key when it is referred to from
another table

= To find and retrieve just the data that meets conditions you
specify, including data from multiple tables, create a query. A query
can also update or delete multiple records at the same time and
perform built-in or custom calculations on your data,

em, which has
ws the

user many different ways in which to re-or

data. A database can handle business inventory, account

filing and use the information in its files to prepare sumo

estimates and other reports. The management of data in a database

system is done by means of a general-purpose software package

called a Database Management System (DBMS). Some

‘commercially available DBMS are MS SQL Server, MS ACCESS,

INGRES, ORACLE, and Sybase.A database management system.

therefore, is a combination of hardware and software that can

be used to set up and monitor a database and can manage the

updating and retrieval of database that has been stored in it. Most of

the database management systems have the following capabilities:

8. - The data stored can be sorted or indexed at the users discretion

and direction

- Various reports can be produced from the system. These may be
either standardized report or that may be specifically

according to specific user definition,

Mathematical functions can be performed, and the data stored in
the database can be manipulated with these functions to perform

the desired calculations,
= To maintain data integrity and database use.

-The DBMS interprets and processes users requests to
retrieve information from a database. In most cases, a query request
will have to penetrate several layers of software in the DBMS and

operating system before the physical database can be accessed

~The DBMS responds to a query by invoking the appropriate

subprograms, each of which performs its special function to interpret

the query, or to locate the desired data in the database and present it
in the desired order

9. What is My SQL?

My

- The management of data in a database system is done by means
neral-purpose software package called a Database
nent System (DBMS). Some commercially available
RDBMS are MS SQL Server, MS ACCESS, INGRES, ORACLE
and Syb:

~ A database is a structured collection of data. It may be anything
from a simple shopping gallery or the vast amounts
of information in a corporate network. To add, access, and process
data stored in a computer database, you need a database management
system such as MySQL Server. Since computers are very good at
handling large amounts of data, database management systems play
a central role in computing, as standalone utilities, or as parts

of other applications,

-A relational database stores data in separate tables rather than
putting all the data in one big storeroom. This adds speed and
flexibility. The SQL part of “MySQL” stands for “Structured
Query Language.” SQL is the most common standardized

10. -language used to access databases and is defined by
the ANSI/ISO SQL Standard. The SQL standard has been

evolving since 1986 and several versions exist, In this manual,
‘SQL-92"refers to the standard released in 1992, “SQL: 1999

refers to the standard released in 1999, and “SQL-2003” refers
to the current version of the standard,

-Open Source means that it is possible for anyone to use and
modify the software, Anybody can download the MySQL
software from the Internet and use it without paying
anything. If you wish, you may study the source code and
change it to suit your needs. The MySQL software uses the
GPL (GNU General Public License).

If that is what you are looking for, you should give it a try
MySQL Server also has a practical set of features developed in

close cooperation with our users. You can find a performance
comparison of MySQL Server with other database managers on

‘our benchmark page, MySQL Server was originally developed to
latabases much faster than existing solutions and
has been successfully used in highly demanding production
‘environments for several years. Although under constant
development, MySQL Server today offers a rich and useful set of
functions. Its connectivity, speed, and security make MySQL
ly suited for accessing databases on the Intemet

QL Database Software is a client/server system that
consists of a multi-threaded SOL server that supports different
backends, several different client programs and libraries,
administrative tools, and a wide range of application
programming interfaces (APIs).

11. What is Pytho

A, python

- Python is an easy to learn, powerful programming language
has efficient high-level data structures and a simple but effective.
approach to object-oriented programming. Python’s elegant syntax
and dynamic typing, together with its interpreted nature, make it an
ideal language for scripting and rapid application development in
many areas on most platforms.

- The Python interpreter and the extensive standard library are -
freely available in source or binary form for all major platforms
from the Python Web site, htps//www.python.org/, and may
be freely distributed. The same site also contains distributions of
and pointers to many free third-party Python modules, programs
and tools, and additional documentation

- The Python interpreter is easily extended with new functions and
data types implemented in C or C++ (or other I

from C)Python is also suitable as an extension ai
customizable applications.

Features of Python

table are many. Some of the most significant features of Python are:

12. ep on

Easy to Code

- Python is a very developer-friendly language which means that
one and everyone can leam to code it in a couple of hours or days.
compared to other object-oriented programming languages like
C, C++, and C#, Python is one of the easiest to learn

Open Source and Free

- Python isan open-source pr language which means that
anyone can create and contribute to its development. Python has an
online forum where thousands of coders gather daily to improve this
language further, Along with this Python is free to download and use
in any operating system, be it Windows, Mac or Linux.

Support for GUI

- GUI or Graphical User Interface is one of the key aspects of any
programming language because it could add fair to code and make
the results more visual. Python has support for a wide array of GUIs
which can easily be imported to the interpreter, thus making this one
of the most favorite languages for developers.

Object-Oriented Approach

- One of the key aspects of Python is its object-oriented approach.
This basically means that Python recognizes the concept of class and
object encapsulation thus allowing programs to be efficient in the

long run,

13. High-Level Language

- Python has been designed to be a high-level programming langua
which means that when you code in Python you don't need to be
aware of the coding structure, architecture as well as memory
management

Integrated by Nature

- Python is an integrated language by nature. This means that the
python interpreter executes codes one line at a time. Unlike other
object-oriented pros guages, we don’t need to compile
python code thus making the debugging process much easier and
efficient. Another advantage of ths is, that upon execution the python
cade is immediately converted into an intermediate form also known
as bytecode which makes it easier to execute and also saves runtime
in the long run

Highly Portable

= Suppose you are running Python on Windows and you need to shift
the same to either a Mac or a Linux system, then you can easily
achieve the same in Python without having to worry about chan;

the code. This is not possible in other programming lang thus
making Python one of the most portable languages available in the
industry

14. The following detail of the MySQL server

connection from Python

= Username - i.e, the username that you use to work with MySQL
Server. The default username for the MySQL database is a root

= Password Password is given by the user at the time of installing
the MySQL database. If you are using root, then you will not need
the password,

- Host Name — is the server's name or Ip address on which MySQL
is running. if you are running on localhost, then you can use localhost
or it is IP ie., 127.0.0.0

- Database Name — Database name to which you want to connect
Steps to connect MySQL database in Python using MySQL

Connector Python

= Use the mysqLeonnector.connect() method of MySQL
Connector Python with required parameters to connect MySQL
= Use the connection object returned by a connect() method to
create a cursor object to perform Database Operations.

- The cursor.execute() to execute SQL queries from Python 5.
Close the Cursor object using a cursor.close() and MySQL

database connection using connection.close() after your work

completes

- Catch Exception if any that may occur during this process,

15. While developing the system, the used hardware is:
PC with Pentium Dual Core processor having 2.00
GB RAM,SVGA and other required devices.

> Microsoft Windows® 10 as Operating System.
> Python 3.7 as Front-end Development
environment.

> MySQL as Back-end Sever with Database for
Testing

> MS-Word for documentation.

SOURCE CODE

creating database OLYMPICS

q puna
rmyawsormyébcuror) u id
int tase cres

creating TABLE SPORTS

16. meu xecutferest table spores
‘orharl20 gender halte in)
prin abled creates)

mycuecereete inset int sorts vols
nur nul nse into ports ales
run area insert into sports values!
curso xecate(intinto sports vals
imycureresecutetneer I sports A

“atelier into sports vals
cursor ante insert into sports vals
mure eme ne In ports vale
meurent por values!
eure net eset into por value
mr encase eset ita sports as
mean area lient sports values!
mean esta insrt into por valves
nur int sport ales
pese erste eset ints spor values
mrursereneanefisert ins sports vals
‘mrcureaxeastel wet into spores vals
musst into sports values

curso exeaste( eset into sports values
mean area nsert ito sports valves
meurent set into sports values!

dd varcha(20,ayernume varchar(20)coutry

aya couse "USA" Mes shot put
"Seat nel, UM" Mens shot put)
AUS Maksim scoro Rusia”, Mens st put?)

BRL331""Shana osa" ai Fong jg"
reese" USAF "Long jump)
ARES" Broche ration" "Aural, lone ume"?
CURZISO" Shara proctor "UI" Long jump")
Canada" Long")
"2109" Ty af”, mia’ Lang Jump

save ton)
ein how)

17. pi mig)

Ascaso cromo”
rem)
prime Ryan ers)

prin" ews"

pana)
pro arney rec]

myeursor.executel create table sportsresus(playeri varchar{20)layemame varchar
(20),countey
varchar(20) gender char( category varchar(20) coach varchar(20) position int medal
varchar(20))

printtable 2 created)

myeursor.enecute(Insert Into sporsresulsvalues"AMO87”,"Rayan erouser","USA"
"Mens shot put"Erikjohrson’,2,"ver"})

18. curo cares to sone value OASIS Aad mus" ata” Men ht
Fre spre U SUM:
Ernennung anzu
Innen to ported NER tig agree 00
truer ower no rss aed TRL" Teta ama Farce 700
turer out or a TT Une ai 0
etes len aes

Fimo io me aver)

fang meet arto Y

‘routs ebene on

row atm alata e

America)

AMERICA] SCORE" 149,20,20,16030,01 "COUNTRY L'ARTAR USK GERMAN" JAMAICA
AUSTRALIA" ORAZL “CATEGORY 1 MENS SHOT PUT: "100 METRES FEMALE” “AVELN
THROW? "10 METRES MALE" LONG JUMP” LONG UNE")

19. conclusion

print CONGRATULATIONS TO THE WINNERS)

Output:

MAIN SCREEN

25. - When a lot of data is being fed into the database it can become a
tedious task to update the database often as the player details and
equipment details can change.

- Also using the software which has been loaded with data may also

Therefore, it is advised to

- MySQL is a language which can be used in any data driven
application SQL based database systems support extracurricular
activities it can not only be used for storing info but also for
manipulating and retrieving data. It also has an option of data
redundancy. Plus with Internet services becoming as active as
ever, the demand for dealing with large amount of data will also
increase, which can be handled by a MYSQL database. Thus, we
‘can say that MySQL has a huge scope in the world of sports.

26. CONCLUSIO:

- Sports management can be managed by a MySQL Database as
we have shown above.

= This will be a step forward to internet services which enables

the user to interact with the national team from anywhere on the

planet. This ensures that players don’t have to physically be
their personal details

27. BIBLIOGRAPHY

Y bttp://www.mysql

¥ htsp://www Python world

Y Ondine Help-of Python

¥ Informatics Practices for class XII

Y Google I

Y NCERT TEXT

Y Various Websites of Discussion Forum and software development activities