Class 12 Computer Science Practical File 2023-2024
Class 12 Computer Science Project File – Student Data management
Class 12 Computer Science Project File – Library Data management
Python Programs
1. Program to add two numbers.
x = int(input('Enter integer value:'))
print('Value entered:', x)
print('Type:', type(x))
2. Program to find simple interest.
p = float(input('Enter principle'))
r = float(input('Enter rate'))
t = float(input('Enter time'))
i=p*r*t/100
print("Interest=",i)
3. Program to check whether a number is even or odd.
a=float(input('Enter a number'))
if a%2==0:
print(a,"is even")
else:
print(a,"is odd")
4. Program to check whether a number is divisible by 2 or 3 using nested if.
num=float(input('Enter a number'))
if num%2==0:
if num%3==0:
print ("Divisible by 3 and 2")
else:
print ("divisible by 2 not divisible by 3")
else:
if num%3==0:
print ("divisible by 3 not divisible by 2")
else:
print ("not Divisible by 2 not divisible by 3")
5. Menu based program to find sum, subtraction, multiplication and division of values.
print("1. Sum of two numbers")
print("2. Subtaction of two numbers")
print("3. Multiplication of two numbers")
print("4. Division of two numbers")
choice=int(input('Enter your choice'))
if choice==1 :
a=int(input('Enter first number'))
b=int(input('Enter second number'))
c=a+b
print("Sum=",c)
elif choice==2 :
a=int(input('Enter first number'))
b=int(input('Enter second number'))
c=a-b
print("Subtraction=",c)
elif choice==3 :
a=int(input('Enter first number'))
b=int(input('Enter second number'))
c=a*b
print("Multiplication=",c)
elif choice==4 :
a=int(input('Enter first number'))
b=int(input('Enter second number'))
c=a/b
print("Division=",c)
else :
print("Wrong choice")
6. Program to print result depending upon the percentage.
a=int(input('Enter your percentage'))
eligible= a>=33
compartment = a>=20 and a<33
fail=a<20
if eligible :
print("Pass");
elif compartment :
print("compartment");
elif fail:
print("Fail");
7. Program to find sum of even numbers from 1 to 7.
sum=0
for num in range(8):
if num%2==0:
sum=sum+num
print("Sum of even values=",sum)
8. Program to find factorial of a number.
n=eval(input("Enter a number="))
i=1
f=1
while i<=n:
f=f*i #1*2*3*4*5
i=i+1
print("Factorial of",n,"=",f)
9. Program to print table of any number.
n=eval(input("Enter a number whose table you want="))
i=1
while i<=10:
print(n,"X",i,"=",n*i)
i=i+1
10. Program to print following pattern.
*
**
***
****
*****
for i in range(1,6):
print()
for j in range(1,i+1):
print ('*',end="")
11. Program to sort values in a list.
aList=[10,5,1,3]
print("Original List",aList)
n=len(aList)
for i in range(n-1):
for j in range(0,n-i-1):
if aList[j]>aList[j+1]:
aList[j],aList[j+1]=aList[j+1],aList[j]
print("Sorted List",aList)
12. Program to find minimum value in a list.
L=eval(input('Enter list values'))
length=len(L) #length=6
min=L[0] #min=10
loc=-1
for i in range(length): #0,1,2,3,4,5
if L[i]<min:
min=L[i] #min=1
loc=i
print("Minimum value=",min)
print("Location=",loc)
13. Program to check whether a value exists in dictionary
aDict={'Bhavna':1,"Richard":2,"Firoza":3,"Arshnoor":4}
val=eval(input('Enter value'))
flag=0
for k in aDict:
if val==aDict[k]:
print("value found at key",k)
flag=1
if flag==0:
print("value not found")
14. Program to find largest among two numbers using a user defined function .
def largest():
a=int(input("Enter first number="))
b=int(input("Enter second number="))
if a>b :
print ("Largest value=%d"%a)
else:
print ("Largest value=%d"%b)
return
largest()
15. Program to find sum of two numbers using a user defined function with parameters.
def sum(a,b): #a and b are formal parameters
c=a+b
print("sum=",c)
sum(4,5)
n1,n2=eval(input('Enter two values'))
sum(n1,n2)
16. Program to find simple interest using a user defined function with parameters and with return value.
def interest(p1,r1,t1 ):
i=p*r*t/100
return(i)
p=int(input("Enter principle="))
r=int(input("Enter rate="))
t=int(input("Enter rate="))
in1=interest(p,r,t)
print("Interest=",in1)
17. Program to pass a list as function argument and modify it.
def changeme( mylist ):
print ("inside the function before change ", mylist)
mylist[0]=1000
print ("inside the function after change ", mylist)
return
list1 = [10,20,30]
print ("outside function before calling function", list1)
changeme( list1 )
print ("outside function after calling function", list1)
18. Program to use default arguments in a function.
def printinfo( name, age = 35 ): #default argument
print ("Name: ", name)
print ("Age ", age)
return
printinfo("aman",45)
printinfo("Parth")
19. Program to write rollno, name and marks of a student in a data file Marks.dat.
count=int(input('How many students are there in the class'))
fileout=open("Marks.dat","a")
for i in range(count):
print("Enter details of student",(i+1),"below")
rollno=int(input("Enter rollno:"))
name=input("name")
marks=float(input('marks'))
rec=str(rollno)+","+name+","+str(marks)+"\n"
fileout.write(rec)
fileout.close()
20. Program to read and display contents of file Marks.dat.
fileinp=open("Marks.dat","r")
while str:
str=fileinp.readline()
print(str)
fileinp.close()
21. Program to read and display those lines from file that start with alphabet ‘T’.
file1=open("data.txt","r")
count=0
str1=file1.readlines()
print(str1)
for i in str1:
if i[0]=='T':
print (i)
file1.close()
22. Program to read and display those lines from file that end with alphabet ‘n’.
file1=open("data.txt","r")
count=0
str1=file1.readlines()
for i in str1:
if i[-2]=='n':
count+=1
print("Number of lines which end with 'n'=",count)
file1.close()
23. Program to count number of words in data file data.txt.
file1=open("data.txt","r")
line=" "
count=0
while line:
line=file1.readline()
s=line.split()
for word in s:
count+=1
print("Number of words=",count)
file1.close()
24. Program to count number of characters in data file data.txt.
file1=open("data.txt","r")
ch=" "
count=0
while ch:
ch=file1.read(1)
count+=1
print("Number of characters=",count)
file1.close()
25. Program to write data in a csv file student.csv.
import csv
fh=open("d:\student.csv","w")
stuwriter=csv.writer(fh)
stuwriter.writerow([1,'aman',50])
stuwriter.writerow([2,'Raman',60])
fh.close()
26. Program to readand display data from a csv file student.csv.
import csv
fh=open("d:\student.csv","r")
stureader=csv.reader(fh)
for rec in stureader:
print(rec)
fh.close()
SQL Queries
SQL 1
(i) Display the Mobile company, Mobile name & price in descending order of
their manufacturing date.
Ans. SELECT M_Compnay, M_Name, M_Price FROM MobileMaster ORDER BY M_Mf_Date DESC;
(ii) List the details of mobile whose name starts with “S”.
Ans. SELECT * FROM MobileMaster WHERE M_Name LIKE “S%‟;
(iii) Display the Mobile supplier & quantity of all mobiles except “MB003‟.
Ans.SELECT M_Supplier, M_Qty FROM MobileStock WHERE M_Id <>”MB003”;
(iv) To display the name of mobile company having price between 3000 & 5000.
Ans. SELECT M_Company FROM MobileMaster WHERE M_Price BETWEEN 3000 AND 5000;
**Find Output of following queries
(v) SELECT M_Id, SUM(M_Qty) FROM MobileStock GROUP BY M_Id;
| MB004 | 450 |
| MB003 | 400 |
| MB003 | 300 |
| MB003 | 200 |
(vi) SELECT MAX(M_Mf_Date), MIN(M_Mf_Date) FROM MobileMaster;
2017-11-20 2010-08-21
(vii) SELECT M1.M_Id, M1.M_Name, M2.M_Qty, M2.M_Supplier FROM MobileMaster M1, MobileStock M2 WHERE M1.M_Id=M2.M_Id AND M2.M_Qty>=300;
| MB004 | Unite3 | 450 | New_Vision |
| MB001 | Galaxy | 300 | Classic Mobile Store |
(viii) SELECT AVG(M_Price) FROM MobileMaster;
5450
SQL 2
i. Display the Trainer Name, City & Salary in descending order of theirHiredate.
Ans. SELECT TNAME, CITY, SALARY FROM TRAINER ORDER BY HIREDATE;
ii. To display the TNAME and CITY of Trainer who joined the Institute in the month of December 2001.
Ans. SELECT TNAME, CITY FROM TRAINER WHERE HIREDATE BETWEEN ‘2001-12-01’ AND ‘2001-12-31’;
iii. To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all those courses whose FEES is less than or equal to 10000.
Ans. SELECT TNAME,HIREDATE,CNAME,STARTDATE FROM TRAINER, COURSE WHERE TRAINER.TID=COURSE.TID AND FEES<=10000;
iv. To display number of Trainers from each city.
Ans. SELECT CITY, COUNT(*) FROM TRAINER GROUP BY CITY;
**Find Output of following queries
v. SELECT TID, TNAME, FROM TRAINER WHERE CITY NOT IN(‘DELHI’, ‘MUMBAI’);
Ans. 103 DEEPTI 106 MANIPRABHA
vi. SELECT DISTINCT TID FROM COURSE;
Ans. 101 103 102 104 105
vii. SELECT TID, COUNT(*), MIN(FEES) FROM COURSE GROUP BY TID HAVING COUNT(*)>1;
Ans.
101 2 12000
viii. SELECT COUNT(*), SUM(FEES) FROM COURSE WHERE STARTDATE< ‘2018-09-15’;
Ans.
4 65000
SQL 3
i) To display details of those Faculties whose salary is greater than 12000.
Ans: Select * from faculty where salary > 12000;
ii) To display the details of courses whose fees is in the range of 15000 to 50000 (both values included).
Ans: Select * from Courses where fees between 15000 and 50000;
iii ) To increase the fees of all courses by 500 of “System Design” Course.
Ans: Update courses set fees = fees + 500 where Cname = “System Design”;
(iv) To display details of those courses which are taught by ‘Sulekha’ in descending order of courses.
Ans: Select * from faculty,courses where faculty.f_id = course.f_id and fac.fname = 'Sulekha' order by cname desc;
**Find output of following
v) Select COUNT(DISTINCT F_ID) from COURSES;
Ans: 4
vi) Select MIN(Salary) from FACULTY,COURSES where COURSES.F_ID = FACULTY.F_ID;
Ans: 6000
vii) Select sum(fees) from COURSES where F_ID = 102;
Ans: 60000
vii) Select avg(fees) from COURSES;
Ans: 17500
SQL 4
i. To display all the details of those watches whose name ends with ‘Time’
Ans select * from watches where watch_name like ‘%Time’;
ii. To display watch’s name and price of those watches which have price range in between 5000-15000.
Ans. select watch_name, price from watches where price between 5000 and 15000;
iii. To display total quantity in store of Unisex type watches.
Ans. select sum(qty_store) from watches where type like ’Unisex’;
iv. To display watch name and their quantity sold in first quarter.
Ans. select watch_name,qty_sold from watches w,sale s where w.watchid=s.watchid and quarter=1;
v. select max(price), min(qty_store) from watches;
Ans. 25000 100
vi. select quarter, sum(qty_sold) from sale group by quarter;
1 15 2 30 3 45 4 15
vii. select watch_name,price,type from watches w, sales where w.watchid!=s.watchid;
HighFashion 7000 Unisex
viii. select watch_name, qty_store, sum(qty_sold), qty_store-sum(qty_sold) “Stock” from watches w, sale s where w.watchid=s.watchid group by s.watchid;
HighTime 100 25 75 LifeTime 150 40 110 Wave 200 30 170 Golden Time 100 10 90
SQL 5
(i) To display the records from table student in alphabetical order as per the name of the student.
Ans. Select * from student order by name;
(ii ) To display Class, Dob and City whose marks is between 450 and 551.
Ans. Select class, dob, city from student where marks between 450 and 551;
(iii) To display Name, Class and total number of students who have secured more than 450 marks, class wise
Ans. Select name,class, count(*) from student group by class having marks> 450;
(iv) To increase marks of all students by 20 whose class is “XII
Ans. Update student set marks=marks+20 where class=’XII’;
**Find output of the following queries.
(v) SELECT COUNT(*), City FROM STUDENT GROUP BY CITY HAVING COUNT(*)>1;
2 Mumbai 2 Delhi 2 Moscow
(vi ) SELECT MAX(DOB),MIN(DOB) FROM STUDENT;
08-12-1995 07-05-1993
(iii) SELECT NAME,GENDER FROM STUDENT WHERE CITY=’Delhi’;
Sanal F Store M
Class 12 Computer Science Project File – Student Data management
Class 12 Computer Science Project File – Library Data management