PM SHRI KENDRIYA VIDYALAYA, BARWAHA

ACADEMIC YEAR : 2024-25

PROJECT REPORT ON

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

ROLL NO :

NAME :

CLASS :

SUBJECT : COMPUTER SCIENCE

SUB CODE : 083

PROJECT GUIDE: Mrs Vaishali Maharana

PGT (CS)

Kendriya Vidyalya, Barwaha

1
 PM SHRI KENDRIYA VIDYALAYA, BARWAHA

CERTIFICATE

This is to certify that Mr./Miss …………… Roll No:……….. has

successfully completed the project Work entitled …………………………………in the

subject Computer Science (083) laid down in the regulations of CBSE for the purpose

of Practical Examination in Class XII to be held in PM Shri Kendriya Vidyalaya,

Barwaha.

Signature of Internal Signature of External

Principal

2
 TABLE OF CONTENTS [ T O C ]

S.NO DESCRIPTION PAGE NO

01 ACKNOWLEDGEMENT 4

02 INTRODUCTION 5

03 OBJECTIVES OF THE PROJECT 6

04 PROPOSED SYSTEM 8

06 SOURCE CODE 9

DATABASE
07. 13

08. OUTPUT 14

09 REFERENCES 15

3
 ACKNOWLEDGEMENT

Efforts and Support: You start by acknowledging that while your efforts were crucial,

the success of the project heavily relied on the encouragement and guidance from

others. This sets the tone for expressing gratitude to those who contributed.

Gratitude to Almighty God: Strength and Completion: You express a deep sense of

gratitude to God for providing you with the strength needed to complete the project.

This reflects your personal belief and recognition of a higher power’s role in your

success.

Gratitude to Parents: Constant Encouragement: You thank your parents for their

unwavering support and encouragement throughout the project. This highlights the

importance of their emotional and possibly financial support in your journey.

Acknowledgment of Individual Contributions: Support Despite Flaws: You

acknowledge the individuals who contributed to the project and continued to support

you despite your imperfections. This shows humility and appreciation for their patience

and understanding.

Principal’s Motivation: You express deep gratitude to the Principal of Kendriya

Vidyalaya, Barwaha, for their continuous motivation and assistance. This indicates the

Principal’s significant role in providing a supportive environment.

Special Thanks to Mrs. Vaishali Maharana: Guide, Mentor, and Friend: You specifically

thank Mrs. Vaishali Maharana, your guide and mentor, who also acted as a friend. Her

4
critical reviews and problem-solving assistance were crucial in overcoming challenges

during the project. This emphasizes her multifaceted role in your success.

General Support and Guidance:

Vital Contributions: You acknowledge the guidance and support from all members who

contributed to the project. This includes those who helped directly or indirectly,

recognizing that their contributions were vital to the project’s success.Constant

Support: You express gratitude for their ongoing support, indicating that their help was

not just a one-time effort but a continuous process throughout the project

5
 PROJECT ON ……………………………………………

INTRODUCTION

When we think about the film industry it means we also need to think about the vast

amount of data generated by this industry due to which it becomes a necessity for film

industry to manage their data efficiently & analysis of this data are essential for

enhancing operation , improving customer experience & driving innovation .

In this project we try to manage data of the movies industry through a user- friendly

python interface & robust MySql database .In this project the user can manage

efficiently the IMDB rating ,duration of movies, etc. across multiple movies . in this

movies management system user can easily search , insert data , update data , view

table & delete records which maintain the integrity & accuracy of data .

In this age of information where data is like a piece of gold for any industry to grow in

this competitive world as we all know that managing data is not luxury it’s a necessity

But the perk is if these data set’s managed efficiently can help in the growth of the

company.

With integration python with MySQL can efficient solution for managing movies .

python’s simplicity & seamless database interaction make easy to manipulate data

which make’s it reliable in various industries .

6
OBJECTIVES OF THE PROJECT

Write Programs Utilizing Modern Software Tools: Modern Software Tools: These

include integrated development environments (IDEs) like Visual Studio Code, Eclipse,

or IntelliJ IDEA, version control systems like Git, and other tools that facilitate software

development.

Practical Application: Students will learn to use these tools to write, test, and debug

their code, which is essential for efficient software development in real-world

scenarios.

Project Development: Students will apply these principles to design and develop small

to medium-sized projects. This helps in creating modular, reusable, and maintainable

code.

Write Effective Procedural Code:

Procedural Programming: This involves writing code in a step-by-step manner, using

procedures or functions to perform tasks.

Problem Solving: Students will develop the ability to write clear and efficient procedural

code to solve specific problems, which is crucial for tasks that do not require the

complexity of OOP.

Demonstrate Breadth of Knowledge in Computer Science:

7
Theory: Knowledge of algorithms, data structures, computational theory, and

complexity.

Conduct Research or Applied Computer Science Projects:

Research Skills: Students will learn to conduct research, which involves identifying a

problem, reviewing existing literature, and proposing solutions.

Applied Projects: These projects require practical application of computer science

principles to solve real-world problems.

8
PROPOSED SYSTEM

This proposed system have following benefits as

Human Fallibility: Humans are inherently prone to making mistakes. In a competitive

business environment, these mistakes can be costly. Automation helps mitigate this risk

by ensuring consistent and accurate performance.

Efficiency and Performance: Automated systems can handle repetitive tasks more

efficiently than humans. They can process large volumes of data quickly and

accurately, leading to better performance and productivity.

Data Management Evolution:

Past: Organizations relied on manual record-keeping, which involved maintaining

physical ledgers and files. This method was not only labor-intensive but also prone to

errors and data loss.

Present: Modern data management software allows organizations to store, manage,

and retrieve data electronically. This transition from paper to digital has streamlined

operations and improved data accuracy.

Software Benefits:

Automation: Tasks that previously required manual effort can now be automated,

reducing the workload on employees and minimizing errors.

Efficiency: Automated systems can perform tasks faster and more accurately than

humans, leading to increased efficiency.

9
Cost-Effectiveness: By reducing the need for manual labor and physical storage,

organizations can save on operational costs.

Accessibility: Digital data can be accessed instantly, providing real-time information

that aids in decision-making.

10
 SOURCE CODE

================================================================
# code for the movie management

import mysql.connector as myc

x = myc.connect(host="localhost",user="root",passwd="pin@53z1985",database="movie_management" )
# connecting py & MySql
mycursor = x.cursor()

print('** =============================== movie management =============================== **')

print('chose the section to work with ')
print('press [10] for MOVIE RECORDS MANIPULATION')
print('press [20] for RECOMMENDATION SYSTEM')

work = int(input('What do you wanna perform :'))

if work == 10:
print('* ===================== *** movie records manipulation *** ===================== *')

print('The operation to perform')

print('press [1] to add record')
print('press [2] to update record')
print('press [3] to delete record')
print('press [4] to view record')
print('press [5] to search record')

manipulation = int(input('Enter the desired operation to perform :'))

# movie management

11
def add_data(q, w, e, r, t, y, u, i):
query = 'insert into movies values({0},{1},{2},{3},{4},{5},{6},{7})'.format(q, w, e, r, t, y, u, i)
mycursor.execute(query)
x.commit()
print('## record saved ##')

def update_data(q, s):

query = 'update movies set IMdb_rating = {0} where movie_id = {1}'.format(q, s)
mycursor.execute(query)
x.commit()
print('## record updated ##')

def delete_data(q):
query = 'delete from movies where movie_id = {}'.format(q)
mycursor.execute(query)
x.commit()
print('## record deleted ##')

def view_table():
query = 'select * from movies '
mycursor.execute(query)
mydata = mycursor.fetchall()
rowc = mycursor.rowcount

print('================================================================================')
print('total no of record found : ', rowc)
for record in mydata:
print(record[0],',',record[1],',',record[2],',',record[3],',',record[4],',',record[5],',',record[6],',',record[7])

def search(q):
query = 'select * from movies where movie_id = {}'.format(q)
mycursor.execute(query)

12
 mydata = mycursor.fetchone()
print(mydata)

if manipulation == 1: # this block is for adding record in the table movies

ans = 'y'
while ans == 'y':
print('================================================================================')
movie_id = int(input('Enter the movie_id :'))
name = input('Enter the name of the movie inside Apostrophe :')
rating = float(input('Enter IMDB rating of the movie :'))
director = input('Enter name of the director of the movie inside Apostrophe :')
actor = input('Enter name of the actor of the movie inside Apostrophe :')
genre = input('Enter genre of the movie inside Apostrophe :')
release_year = input('Enter release year of the movie inside Apostrophe :')
duration = input('Enter duration of the movie inside Apostrophe :')

add_data(movie_id,name,rating,director,actor,genre,release_year,duration)

ans = input('do you wanna add more y/n :')

elif manipulation == 2: # this block is for updating existing record in the table movies
ans = 'y'
while ans == 'y':
print('================================================================================')
movie_id = int(input('Enter movie Id of the movie which you want to update :'))
new_imdb = float(input('Enter the new imdb rating of the movie :'))

update_data(movie_id, new_imdb)

ans = input('do you wanna update more y/n :')

elif manipulation == 3: # this block is for deleting existing record in the table movies
ans = 'y'
while ans == 'y':
print('================================================================================')

13
 movie_id = int(input('Enter the movie Id to delete :'))

delete_data(movie_id)

ans = input('do you wanna delete more y/n :')

elif manipulation == 4: # this block is for viewing record in the table movies
print('================================================================================')
view_table()

elif manipulation == 5: # this block is for searching existing record in the table movies
ans = 'y'
while ans == 'y':
print('')
movie_id = int(input('Enter movie_id of the movie which you wanna search :'))
search(movie_id)
ans = input('enter do you wanna search again y/n :')

elif work == 20:

print('=============================== recommendation system ===============================')
print('the operation to perform')
print('press [1] to get best movies of the director')
print('press [2] to get best movies in the genre')
print('press [3] to get top movies according to imdb rating ')

recommendation = int(input('Enter the type of recommendation you want to get :'))

# recommendation system

def DIRECTOR(x,y):
query = 'select * from movies where director = {} and IMdb_rating > {}'.format(x, y)
mycursor.execute(query)
mydata = mycursor.fetchall()
for record in mydata:

14
 print(record[0],',',record[1],',',record[2],',',record[3],',',record[4],',',record[5],',',record[6],',',record[7])

def IMDB(x):
query = 'select * from movies where IMdb_rating > {}'.format(x)
mycursor.execute(query)
mydata = mycursor.fetchall()
for record in mydata:
print(record[0],',',record[1],',',record[2],',',record[3],',',record[4],',',record[5],',',record[6],',',record[7])

def GENRE(x, y):

query = 'select * from movies where genre = {} and IMdb_rating > {}'.format(x, y)
mycursor.execute(query)
mydata = mycursor.fetchall()
for record in mydata:
print(record[0],',',record[1],',',record[2],',',record[3],',',record[4],',',record[5],',',record[6],',',record[7])

if recommendation == 1:
director = input('enter the name of the director for his best movies inside Apostrophe :')
imdb = float(input('enter the desired value of imdb according to you :'))

DIRECTOR(director,imdb)

elif recommendation == 2:
genre = input('enter the genre of which you want recommendation for the movie inside Apostrophe :')
imdb = float(input('enter the desired value of imdb according to you :'))

GENRE(genre,imdb)

elif recommendation == 3:
imdb = float(input('enter the desired value of imdb according to you :'))
IMDB(imdb)
x.close()

15
16
==================================================================== DATABASE
: MYSQL TABLES

17
OUTPUT

18
 REFERENCES

1. Computer science With Python - Class XI By : Sumita Arora

2.Website: https://www.youtube.com
3. Website : https://www.imdb.com
4. Website : https://www.netflix.com
5. Website : https://www.vogue.in

***

19