KENDRIYA VIDYALAYA NO.

1 JALAHALLI WEST,
BANGALORE

A PROJECT REPORT
ON
MYSORE ZOO ANIMAL CLASSIFICATION
FOR
CBSE 2023 EXAMINATION
[AS A PART OF THE INFORMATICS PRACTICES(065)]
DONE BY
ALEENA MAHEEN
SUBMITTED BY
ALEENA MAHEEN

UNDER THE GUIDANCE OF:

MRS. DIVYA
PGT (COMP.SC)
 CERTIFICATE
This is to certify that the Project / Dissertation
entitled
“MYSORE ZOO ANIMAL CLASSIFICATIONS”
is a work done by
ALEENA MAHEEN
of Class XII Session 2022-23 in partial fulfilment of
CBSE Examination 2023 and has been carried out
under my direct supervision and guidance. This
report or a similar report on the topic has not
been submitted for any other examination and
does not form a part of any other course
undergone by the candidate.

………………………. …………………………

Signature of Teacher/Guide
Signature of the Principal
Name: MRS. DIVYA
Designation: PGT (Comp.Sc.)
 ACKNOWLEDGEMENT
I undertook this Project work, as the part of my XII-
Computer Science course. I have tried to apply 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.
I would like to extend my sincere thanks and gratitude to my
teacher MRS DIVYA C. K PGT (Comp.Sc).
I am very much thankful to our Principal Shri. RAVINDRE S
DEVADIGA for giving valuable time and moral support to
develop this software.
I would like to take the opportunity to extend my sincere
thanks and gratitude to our parents for being a source of
inspiration and providing time and freedom to develop this
software project.
 CONTENTS
1. CERTIFICATE

2. ACKNOWLEDGEMENT

3.AIM

4. INTRODUCTION

5.THEORITICAL APPROACH

6. TABLE STRUCTURE

7. CODING

8. CONCLUSIONS

9. BIBLOGRAPHY
 AIM
THE MAIN AIM OF THIS PROJECT IS TO PLAY

QUIZ WITH PEOPLE TO ENHANCE THEIR

KNOWLEDGE .

IT HELPS TO STORE ALL THE QUESTIONS

INPUTTED ONCE AND PARTICULAR QUESTION

CAN BE EASILY ACCESSED BY THE PERSON IN

FAST MANNER.
 INTRODUCTION
This project has been made for learning new facts in
easer way by playing quiz with friends
It contains the all the question which user wants to
input for the exam
This software, being simple in design and working,
does not require much of training to users, and can be
used as a tool for keeping records.
During coding and design of the software Project,
python IDLE, a user friendly envirourment based
integrated platform and coding simplicity. As a back-
end, an open source RDBMS, My SQL is used as per
requirement of the CBSE curriculum of Informatics
Practices Course.
 THEORITICAL APPROACH
What is Python?
Python is an interpreted, object-oriented, high-level
programming language with dynamic semantics. Its
high-level built in data structures, combined with
dynamic typing and dynamic binding, make it very
attractive for Rapid Application Development, as well
as for use as a scripting or glue language to connect
existing components together. Python's simple, easy
to learn syntax emphasizes readability and therefore
reduces the cost of program maintenance. Python
supports modules and packages, which encourages
program modularity and code reuse. The Python
interpreter and the extensive standard library are
available in source or binary form without charge for
all major platforms, and can be freely distributed.
Often, programmers fall in love with Python because
of the increased productivity it provides. Since there is
no compilation step, the edit-test-debug cycle is
incredibly fast. Debugging Python programs is easy: a
bug or bad input will never cause a segmentation
fault. Instead, when the interpreter discovers an error,
it raises an exception. When the program doesn't
catch the exception, the interpreter prints a stack
trace. A source level debugger allows inspection of
local and global variables, evaluation of arbitrary
expressions, setting breakpoints, stepping through
the code a line at a time, and so on. The debugger is
written in Python itself, testifying to Python's
introspective power. On the other hand, often the
quickest way to debug a program is to add a few print
statements to the code
Features of Python:
Python provides lots of features that are listed
below.
1) Easy to Learn and Use
Python is easy to learn and use. It is developer-
friendly and high-level programming language.
2) Expressive Language
Python language is more expressive means that it is
more understandable and readable.
3) Interpreted Language
Python is an interpreted language i.e. interpreter
executes the code line by line at a time. This makes
debugging easy and thus suitable for beginners.
4) Cross-platform
Language Python can run equally on different
platforms such as Windows, Linux, Unix and
Macintosh etc. So, we can say that Python is a
portable language.
5) Free and Open Source
Python language is freely available at official web
address. The source-code is also available. Therefore,
it is open source.
6) Object-Oriented Language
Python supports object-oriented language and
concepts of classes and objects come into existence.
7) Extensible
It implies that other languages such as C/C++ can be
used to compile the code and thus it can be used
further in our python code.
8) Large Standard Library
Python has a large and broad library and provides rich
set of module and functions for rapid application
development.
9) GUI Programming Support
Graphical user interfaces can be developed using
Python.
What is Database?
Introduction and Concepts:
A database is a collection of information related
to a particular subject or purpose, such as tracking
customer orders or maintaining a music collection.
Using any RDBMS application software like MS SQL
Server, MySQL, Oracle, Sybase etc., you can manage
all your information from a single database file. Within
the file, divide your 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 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 it is referred to from
another table.

Role of RDBMS Application Program:

A computer database works as a electronic filing
system, which has a large number of ways of cross-
referencing, and this allows the user many different
ways in which to re-organize and retrieve data. A
database can handle business inventory, accounting
and filing and use the information in its files to prepare
summaries, 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
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.
What is MySQL?
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 RDBMS are MS
SQL Server, MS ACCESS, INGRES, ORACLE, and
Sybase.
 MySQL, the most popular Open Source SQL
database management system, is developed,
distributed, and supported by Oracle Corporation.
MySQL is named after co-founder Monty Widenius's
daughter, Me. The name of the MySQL Dolphin (our
logo) is “Sakila,”.

MySQL is a database management system.

A database is a structured collection of data. It may
be anything from a simple shopping list to picture
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.
MySQL is based on SQL.
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 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.

MySQL software is Open Source.

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), The MySQL Database Server is very fast,
reliable, and easy to use.
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 handle large databases 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 Server highly suited for accessing databases
on the Internet.
MySQL Server works in client/server or embedded
systems.
The MySQL Database Software is a client/server
system that consists of a multi-threaded SQL server
that supports different backends, several different
client programs and libraries, administrative tools, and
a wide range of application programming interfaces
(APIs).

The Main Features of MySQL

● Written in C and C++.
● Works on many different platforms. Uses multi-
layered server design with independent
modules.
● Provides transactional and non-transactional
storage engines.
● Designed to make it relatively easy to add other
storage engines. This is useful if you want to
provide an SQL interface for an in-house
database.
● Uses a very fast thread-based memory allocation
system.
● Executes very fast joins using an optimized
nested-loop join.
● Implements SQL functions using a highly
optimized class library that should be as fast as
 possible. Usually there is no memory allocation
at all after query initialization.
● Provides the server as a separate program for
use in a client/server networked environment,
and as a library that can be embedded (linked)
into standalone applications. Such applications
can be used in isolation or in environments
where no network is available.
● Password security by encryption of all password
traffic when you connect to a server.
THE HARDWARE USED:
While developing the system, the used hardware is:

THE SOFTWARE’S USED:

● Microsoft Windows® 10 Home as Operating

System.
● Python 3.8.1as Front-end Development
environment.
● MySQL as Back-end Sever with Database for
Testing.
● MS-Word 2019 for documentation.
● Snipping tool for screenshot’s
TABLE STRUCTURE
Coding
 CONCLUSIONS

“EXAM CONTAST”
has been prepared to reduce
manual work
and with the help of this project all
the work
can be done automatically in fast
manner.
 BIBLOGRAPHY

In order to work on this project titled – EXAM

CONTAST
the following books and literature are referred by
me during
the various phases of development of the project.
1. NCERT Informatics Practices Class XII
2. On-line Help of python ®
3. Computer science for class XII-by Sumita Arora
4. Computer science for class XI-by Sumita Arora
5. http://www.mysql.org/
6. http://www.python.org/
7. http:// stackoverflow.com/
Other than the above-mentioned books, the
suggestions and supervision of my teacher and my
class experience also helped me to develop this
software project.