Scribd
Upload
33 views

Practical File Programs (Class11)

Uploaded by

Priyanshu Dubey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
33 views

Practical File Programs (Class11)

Uploaded by

Priyanshu Dubey
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 14

Program 13

Write a program to find maximum and minimum element in a


list. List is inserted by user.
Solution
l=[]
n=int(input("Enter A Number"))
for i in range(0,n+1):
num=int(input("enter number to insert"))
l.append(num)
print("Maximum=",max(l))
print("Minimum=",min(l))

Output
Program 14
Write a program to print the frequency of the number from
a list if no not in a list then print no not found.
Solution:
count=0
l=[]
n=int(input("enter limit"))
for i in range(0,n):
num=int(input("enter no to insert list"))
l.append(num)
ser=int(input("enter number"))
for i in range(0,n):
if l[i]==ser:
count=count+1
if(count==0):
print("no not find")
else:
print("frequency=",count)

Output
Program 15
Write a program to input a list of n integers and find their
median.
Solution:
val=eval(input("Enter a list:"))
val.sort()
s=len(val)
mid=s//2
if s%2==0:
m1,m2=mid-1,mid
med=(val[m1]+val[m2])/2
else:
med=val[mid]
print("Median of given list is : ",med)

Output
Program 16
Write a code to calculate and display total marks and
percentage of a student from the given list storing marks
of a student.

Solution
sum=0
l=[ ]
n=int(input("enter limit"))
for i in range(0,n):
num=int(input("enter no. to insert in a list"))
l.append (num)
for i in range(len(l)):
sum=sum+l[i]
avg=sum/len(l)
print("total marks=",sum)
print("average marks=",avg)

OUTPUT
Program 17
Write a program to find the number of occurences of each
vowel present in input string.

SOLUTION
word=input('Enter string')
vowels={'a','e','i','o','u'}
d={ }
for i in word:
if i in vowels:
d[i]=d.get(i,0)+1
for k,v in sorted (d.items( )):
print(k,"occured",v,"times")

OUTPUT
Program 18
WAP to create a dictionary with keys as first characters and
value as words starting with characters

Solution
s=input("enter string")
l=s.split()
d={}
for i in l:
if (i[0] not in d.keys()):
d[i[0]]=[]
d[i[0]].append(i)
else:
if i not in d[i[0]]:
d[i[0]].append(i)
for k,v in d.items():
print(k,":",v)

Output
Program 19
WAP to store students name and their percentage in dictionary,
delete particular student name from dictionary .Also display
dictionary after deletion.

Solution
d={}
ch=1
n=int(input ("Enter a no of enteries"))
while ch<=n:
name=input ("Enter Name")
per=int(input("Enter Percentage"))
d[name]=per
ch=ch+1
b=d.keys()
print(d)
ser=input("Enter Name for Deletion")
for i in b:
if i ==ser:
d.pop(i)
print("After Deletion=",d)

Output
Program 20

Write a program to create a third dictionary from two


dictionaries having some common keys, in way so that the
values of common keys are added in the third dictionary.

Solution
d1={'1':100,'2':200,'3':300}
d2={'1':300,'2':200,'5':400}
d3=dict(d1)
d3.update(d2)
for i,j in d1.items():
for x,y in d2.items():
if i==x:
d3[i]=(j+y)
print("The Resultant Dictionary : ")
print(d3)

Output
SQL Based Queries Program
Program 1
(A) Create Database ‘Hospital’

(B) Open database ‘Hospital’

(C) Create a table ‘Doctor’ with following structure:


FieldName Datatype Key
Doc_ID Char(4) Primary Key
Doc_Name Varchar(30)
Doc_Speciality Varchar(30)
Mobile Varchar(10)
Address Varchar(30)
Salary Integer

(D) Display the structure of table ‘Doctor’

(E) Add one more column DOJ with Date datatype.


(F) Insert the following record:
(D101,Dr.Vaibhav,ENT,987345321,Delhi,2010-02-12.)

(G) Change to datatype of column Doc_Name from Varchar(30) to


Varchar(10).

(H) Rename the column Mobile to Contact.

(I) Delete column Address.

(J) Delete table Doctor.


Program 2
A) Create table books with appropriate data type.

B) Insert record (‘K01’,’Black book(Java)’,’FIRST


PUBL’,600,’Computer’,60)-

C) Add a new column author-

D) Update author name ‘Y.Kanatkar’ for B_id ‘K01’.

E) Show books of FIRST PUBL –

F) To display the cost of all book published by ‘EPB’.

G) Depriciate the price of all books of EPB Publisher by10 %.


H) To display the Book_name , Price of book more than 24 Qty.

I) To show the details of book whose name ends with ‘e’.

J) To display all records in descending order by price.


Program 3
Create a below given Student Table
Roll_no Stu_Name Class Sections Marks
101 Rohit 10 A 412
102 Alok 10 A 526
103 Roohi 9 B 427
104 Alka 10 B 500
105 Rahul 9 A 226
a) Create a table with appropriate data types.

b) Description of table

c) Insert data in the student table

d) Display all data


e) Delete the details of a particular student in the above table.

You might also like