ADITYA VIDYASHRAM RESIDENTIAL SCHOOL

PUDUCHERRY
ACADEMIC YEAR 2024-2025

COMPUTER SCIECNE-PRACTICAL MANUAL (XII)

MYSQL
EX.NO NAME OF THE PROGRAM DATE
1 MYSQL(Games-Player) 17.05.2024
2 MYSQL(Faculty-Courses) 18.05.2024
3 MYSQL(Graduate) 04.06.2024
4 MYSQL(Sender-Recipients) 15.06.2024
5 MYSQL(Trainer-Course) 21.06.2024
PYTHON PROGRAMS
1 Factorial Of A Number 03.07.2024
2 Random Number Generation(1-6) 03.07.2024

3 Prime Number checking 03.07.2024

4 Perfect number or not 03.07.2024

5 Arithmetic operations 03.07.2024

6 Computing the area of triangle and circle using function. 11.07.2024

7 Counting a word in a given sentence 11.07.2024

8 Reading a text file 11.07.2024

9 Merge two dictionaries 11.07.2024

10 Addition of two matrices using nested loop 20.07.2024

11 Counting total no. of consonants, vowels in a text file 20.07.2024
12 Copying a file 07.08.2024
13 Creation of a binary file. 07.08.2024
14 Updating a binary file 19.08.2024
15 Creation of a CSV file 21.08.2024
16 Implementation of stack operations 23.08.2024
17 Create, insert mysql table using python program. 27.08.2024
18 Searching a value in a Mysql table using python program. 28.08.2024
19 Update a value in a Mysql table using python. 29.08.2024
20 Delete a value in a Mysql table using python. 31.08.2024
Q1: Write a Python Program to Input any number from user and calculate factorial of a
number
CODING :
num = int(input("Enter any number :"))
fact = 1
a=1
while a<=num :
fact = fact * a
a=a+1
print("Factorial of ", num , " is :",fact)

OUTPUT
Enter any number :6
Factorial of 6 is : 720
===========================================================================
Q2:Write a Python program for random number generation that generates random
numbers between 1 to 6 (simulates a dice).
CODING:
import random
while True :
choice=input("Enter 'r' to roll dice or press any other key to quit: ")
if(choice!="r"):
break
n=random.randint(1,6)
print(n)
OUTPUT
Enter 'r' to roll dice or press any other key to quit: r
4
Enter 'r' to roll dice or press any other key to quit: r
3
Enter 'r' to roll dice or press any other key to quit:
============================================================================
Q3: W rite a Python p rog ra m to i nput any number from user and check it is Prime no.
or not
CODING:
num = int(input("Enter any number :"))
isPrime=True
for i in range(2,num):
if num % i == 0:
isPrime=False
break
if isPrime==True:
print("## Number is Prime ##")
else:
print("## Number is not Prime ##")
OUTPUT
Enter any number :20
## Number is not Prime ##
>>>
 Enter any number :19
## Number is Prime ##
============================================================================
Q4:Write a program to find whether an inputted number is perfect or not.

Output:

============================================================================
Q5: Write a python Program to enter two numbers and print the
arithmetic operations like +,-,*, /, // and %.
CODING :

Output:
Q 6: Write a python program to Computing the area of triangle and circle .
CODING :
def tarea(b,h):
a=½ *b*h
return a
def carea(r):
a = 22/7 * r *r
return a
while(1):
print(" Menu")
print("1. Area of Triangle")
print("2. Area of Circle")
print("3. Exit")
ch = int(input("Enter your choice:"))
if(ch==1):
b = float(input("Enter the base of triangle : "))
h = float(input("Enter the height of triangle : "))
print("The area of triangle : ", tarea(b,h))
elif(ch==2):
r = float(input("Enter the radius of circle :"))
print("The area of circle :", carea(r))
elif (ch==3):
break
else:
print("Wrong Choice")
OUTPUT:
Menu
1.Area of triangle
2.Area of Circle
3.Exit
Enter your choice 2
Enter the radius of circle:1
The area of circle:3.14159
Menu
1.Area of triangle
2.Area of Circle
3.Exit
Enter your choice 1
Enter the base of triangle :10
Enter the height of triangle : 5
The area of triangle : 25.0
Menu
1.Area of triangle
2.Area of Circle
3.Exit
Enter your choice 3
============================================================================
 Q7: Write a python Program to search any word in a given sentence.
def countWord(str1,word):
s = str1.split()
count=0
for w in s:
if w==word:
count+=1
return count
str1 = input("Enter any sentence :")
word = input("Enter word to search in sentence :")
count = countWord(str1,word)
if count==0:
print("## Sorry! ", word," not present ")
else:
print("## ",word," occurs ",count," times ## ")
OUTPUT
Enter any sentence :
my computer your computer our computer everyones computer
Enter word to search in sentence :computer
## computer occurs 4 times ##
>>>
Enter any sentence :learning python is fun
Enter word to search in sentence :java
## Sorry! java not present
============================================================================
Q8: Write a python Program to read and display file content line by line with each
word separated by "#‟
CODING :
f = open("file1.txt")
for line in f:
words = line.split()
for w in words:
print (w +'#',end='')
print()
f.close()

input:
if the original content of file is:
India is my country
I love python

OUTPUT
India#is#my#country#
I#love#python#
======================================================================
Q 9: Write a python Program to merge two dictionaries
def Merge(dict1, dict2):
return(dict2.update(dict1))
dict1 = {'a': 10, 'b': 8}
dict2 = {'d': 6, 'c': 4}
 print(Merge(dict1,
dict2))
print(dict2)
Output:
None
{‘d’:6,'c': 4, 'a': 10, 'b': 8 }
==========================================================================
Q10 : Write a python Program to add two matrices using nested loop.
X = [[1,2,3],[4 ,5,6],[7 ,8,9]]
Y = [[9,8,7], [6,5,4], [3,2,1]]
result = [[0,0,0], [0,0,0],[0,0,0]]
for i in range(len(X)):
for j in range(len(X[0])):
result[i][j] = X[i][j] + Y[i][j]
for r in result:
print(r)
Output:
[10, 10, 10]
[10, 10, 10]
[10, 10, 10]
===========================================================================
Q11: Write a python Program to read the content of file and display the total number
of Consonants, uppercase, vowels and lowercase characters.‟
f = open("file1.txt")
v=c= u= l=0
data = f.read()
for ch in data:
if ch.isalpha():
if ch.lower() in “aeiou”:
v+=1
else:
c+=1
if ch.isupper():
u+=1
elif ch.islower():
l+=1
print("Total Vowels in file :", v)
print("Total Consonants in file :",c)
print("Total Capital letters in ile :",u)
print("Total Small letters in file :",l)
f.close()
input:
if the original content of file is:
India is my country
I love python
Python learning is fun 123@

OUTPUT
Total Vowels in file : 16
Total Consonants in file : 30
Total Capital letters in file : 3
Total Small letters in file : 44
 ===============================================
Q12:Write a Python Program to read the content of file line by line and write it
toanother file except for that lines contains "a‟ letter in it.
f1 = open("file2.txt")
f2 = open("file2copy.txt","w")
for line in f1:
if 'a' not in line:
f2.write(line)
print(“## File Copied Successfully! ##”)
f1.close()
f2.close()

INPUT:
Content of file2.txt
a quick brown fox
one two three fourfive six seven
India is my country
eight nine ten
bye!
OUTPUT
## File Copied Successfully! ##
After copy content of file2copy.txt
one two three fourfive six seven
eight nine ten
bye!
============================================================================
Q13: W ri t e a P yh to n Program to create binary file to store Rollno and Name,
Search any Rollno and display name if Rollno found otherwise “Rollno not found”
import pickle
student=[]
f=open('student.dat','wb')
ans='y'
while ans.lower()=='y':
roll = int(input("Enter Roll Number :"))
name = input("Enter Name :")
student.append([roll,name])
ans=input("Add More ?(Y)")
pickle.dump(student,f)
f.close()
f=open('student.dat','rb')
student=[]
while True:
try:
student = pickle. load(f)
except EOFError:
break
ans='y'
while ans.lower()=='y':
found=False
r = int(input("Enter Roll number to search :"))
 for s in student:
if s[0]==r:
print("## Name is :",s[1], " ##")
found=True
break
if f o u n d= =F al s e :
print("####Sorry! Roll number not found ####")
ans=input("Search more ?(Y) :")
f.close()
OUTPUT
Enter Roll Number :1
Enter Name :Amit
Add More ?(Y)y
Enter Roll Number :2
Enter Name :Jasbir
Add More ?(Y)n
Enter Roll number to search :2
## Name is : Jasbir ##
Search more ?(Y) :y
Enter Roll number to search :4
####Sorry! Roll number not found ####
Search more ?(Y) :n
============================================================================
Q14: Write a python Program to create binary file to store Rollno, Name and Marks
and update marks of entered Rollno.
import
pickle
student=[]
f=open('student.dat','wb')
ans='y'
while ans.lower()=='y':
roll = int(input("Enter Roll Number :"))
name = input("Enter Name :")
marks = int(input("Enter Marks :"))
student.append([roll,name,marks])
ans=input("Add More ?(Y)")
pickle.dump(student,f)
f.close()
f=open('student.dat','rb+')
student=[]
while True:
try:
student = pickle.load(f)
except EOFError:
break
ans='y'
while ans.lower()=='y':
found=False
r = int(input("Enter Roll number to update :"))
for s in student:
if s[0]==r:
m = int(input("Enter new marks :"))
s[2]=m
 print("## Record Updated ##")
found=True
break
if not found:
print("####Sorry! Roll number not found ####")
ans=input("Update more ?(Y) :")
f.close()
OUTPUT
Enter Roll Number :1
Enter Name :Amit
Enter Marks :99
Add More ?(Y)y
Enter Roll Number :2
Enter Name :Vikrant
Enter Marks :88
Add More ?(Y)n
Enter Roll number to update :2
Enter new marks :90
## Record Updated ##
Update more ?(Y) :y
Enter Roll number to update :2
Enter new marks :95
## Record Updated ##
Update more ?(Y) :n
==============================================================================
Q15: Write a Python script to write VOTER.CSV file containing Voter_Id, VoterName, VoterAge having
comma as a delimiter. Display those records where voter age is more than 65.
import csv
f=open("VOTER.csv","w",newline="")
a=csv.writer(f)
a.writerow(["Voter_ID","VoterName","VoterAge"])
a.writerow(["ABZ1234560","Rajeev","67"])
a.writerow(["AHZ1234870","Sonali","72"])
a.writerow(["BJZ1234350","Ankita","27"])
a.writerow(["CBK9834560","Gaurav","21"])
f.close()
f=open("VOTER.csv", "r", newline="")
l=[]
r=csv.reader(f)
for i in r:
l.append(i)
for j in l:
if j==l[0]:
continue
else:
if int(j[-1])>65:
print(j)
f.close()

OUTPUT:
Q16 :write a menu driven program to implement stack operation using a list.
st=[]
while(1):
print ("1. PUSH")
print ("2. POP ")
print ("3. Display")
print("4.Exit")
choice=int(input("Enter your choice: "))
if (choice==1):
a=int(input("Enter any number :"))
st.append(a)
elif (choice==2):
if (st==[]):
print ("Stack Empty" )
else:
print ("Deleted element is : ",st.pop())
elif (choice==3):
length=len(st)
for i in range(length-1,-1,-1):
print (st[i])
elif (choice ==4):
break
else:
print("Invalid Input")

output:

1.PUSH
2.POP
3.Display
4.Exit
Enter your choice: 1
Enter any number:25
1.PUSH
2.POP
3.Display
4.Exit
Enter your choice: 1
Enter any number:10
1.PUSH
2.POP
3.Display
4.Exit
Enter your choice: 2
Deleted elements is :10
1.PUSH
2.POP
3.Display
4.Exit
Enter your choice: 3
25
1.PUSH
2.POP
3.Display
4.Exit
Enter your choice: 4
P17: Program to connect with database and store record of employee
and display records.
import mysql.connector as mycon
con = mycon.connect(host='127.0.0.1',user='root',password="admin"
database=”company”)
cur = con.cursor()
cur.execute("create table employee(empno int, name varchar(20), dept
varchar(20),salary int)")
con.commit()
choice=None
while choice!=0:
print("1. ADD RECORD ")
print("2. DISPLAY RECORD ")
print("0. EXIT")
choice = int(input("Enter Choice :"))
if choice == 1:
e = int(input("Enter Employee Number :"))
n = input("Enter Name :")
d = input("Enter Department :")
s = int(input("Enter Salary :"))
query="insert into employee values({},'{}','{}',{})".format(e,n,d,s)
cur.execute(query)
con.commit()
print("## Data Saved ##")
elif choice == 2:
query="select * from employee"
cur.execute(query)
result = cur.fetchall()
for row in result:
print(row[0],row[1],row[2],row[3])
elif choice==0:
con.close()
print("## Bye!! ##")
else:
print("## INVALID CHOICE ##")
OUTPUT

0. ADD RECORD
1. DISPLAY RECORD
0. EXIT
Enter Choice :1
Enter Employee Number :1
Enter Name :AMIT
Enter Department :SALES
Enter Salary :9000
## Data Saved ##
1. ADD RECORD
2. DISPLAY RECORD
0. EXIT
Enter Choice :1
Enter Employee Number :2
Enter Name :NITIN
Enter Department :IT
Enter Salary :80000 ##
Data Saved ##
1. ADD RECORD
2. DISPLAY RECORD
0. EXIT
Enter Choice :2
EMPNO NAME DEPARTMENT SALARY
1 AMIT SALES 9000
2 NITIN IT 80000
1. ADD RECORD
2. DISPLAY RECORD
0. EXIT
Enter Choice :0##
Bye!! ##
P18: Program to connect with database and search employee
number in table employee and display record, if empno not found
display appropriate message.
import mysql.connector as mycon
con = mycon.connect(host='127.0.0.1',user='root',password="admin",
database="company")
cur = con.cursor()
ans='y'
while ans.lower()=='y':
eno = int(input("ENTER EMPNO TO SEARCH :"))
query="select * from employee where
empno={}".format(eno) cur.execute(query)
result = cur.fetchall()
if cur.rowcount==0:
print("Sorry! Empno not found ")
 else:
for row in result:
print(row[0], row[1], row[2], row[3])
ans=input("SEARCH MORE (Y) :")

OUTPUT

ENTER EMPNO TO SEARCH :1

1 AMIT SALES 9000
SEARCH MORE (Y) :y
ENTER EMPNO TO SEARCH :2
2 NITIN IT 80000
SEARCH MORE (Y) :y
ENTER EMPNO TO SEARCH :4
Sorry! Empno not found
SEARCH MORE (Y) :n
 P19: Program to connect with database and update the employee record of
entered empno.
import mysql.connector as mycon
con = mycon.connect(host='127.0.0.1',user='root',password="admin", database="company")
cur = con.cursor()
ans='y'
while ans.lower()=='y':
eno = int(input("ENTER EMPNO TO UPDATE :"))
query="select * from employee where empno={}".format(eno)
cur.execute(query)
result = cur.fetchall()
if cur.rowcount==0:
print("Sorry! Empno not found ")
else:
for row in result:
print(row[0], row[1], row[2], row[3])
choice=input("\n## ARE YOUR SURE TO UPDATE ? (Y) :")
if choice.lower()=='y':
d = input("ENTER NEW DEPARTMENT,(LEAVE BLANK IF NOT WANT

TO CHANGE )")
if d==" ":
d=row[2]
try: s = int(input("ENTER NEW SALARY,(LEAVE BLANK IF NOT

WANT TO CHANGE ) "))

except:
s=row[3]
query="update employee set dept='{}',salary={} where empno={}".format
(d,s,eno)
cur.execute(query) con.commit()
print("## RECORD UPDATED ## ")
ans=input("UPDATE MORE (Y) :")
 OUTPUT:
EMPNO TO UPDATE :2
2 NITIN IT 90000
## ARE YOUR SURE TO UPDATE ? (Y) :y
ENTER NEW DEPARTMENT,(LEAVE BLANK IF NOT WANT TO CHANGE )
ENTER NEW SALARY,(LEAVE BLANK IF NOT WANT TO CHANGE )
## RECORD UPDATED ## UPDATE MORE (Y) :Y
ENTER EMPNO TO UPDATE :2
2 NITIN SALES 90000
## ARE YOUR SURE TO UPDATE ? (Y) :
N UPDATE MORE (Y) :N

P20: Program to connect with database and delete the record of

entered employee number.
import mysql.connector as mycon
con = mycon.connect(host='127.0.0.1',user='root',password="admin", database="company")
cur = con.cursor()
ans='y'
while ans.lower()=='y':
eno = int(input("ENTER EMPNO TO DELETE :"))
query="select * from employee where empno={}".format(eno) cur.execute(query)
result = cur.fetchall()
if cur.rowcount==0:
print(“Sorry! Empno not found “)
else:
for row in result:
print(row[0], row[1], %row[2], row[3])
choice=input("\n## ARE YOUR SURE TO DELETE ? (Y) :")
if choice.lower()=='y':
query="delete from employee where empno={}".format(eno)
cur.execute(query)
con.commit()
print("=== RECORD DELETED SUCCESSFULLY! ===")
ans=input("DELETE MORE ? (Y) :")
OUTPUT
ENTER EMPNO TO DELETE :2
2 NITIN SALES 91000
## ARE YOUR SURE TO DELETE ? (Y) :y
=== RECORD DELETED SUCCESSFULLY! ===
DELETE MORE ? (Y) :y
ENTER EMPNO TO DELETE :2
Sorry! Empno not found
DELETE MORE ? (Y) :n