Preview

# Class 12 Computer Science Practical File 2022-2023

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")
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
print("value found at key",k)
flag=1
if flag==0:

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:
print(str)
fileinp.close()```

```file1=open("data.txt","r")
count=0
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
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:
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:
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")
print(rec)
fh.close()
```

## 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
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