PRACTICLE FILE
COMPUTER SCIENCE
SESSION 2022-23
NAME: Ronish Singh
CLASS: XII – B
ROLL NO: 30
SCHOOL: MAXFORT SCHOOL DWARKA, NEW
DELHI
Acknowledgement
I wish to express my great gratitude and sincere thanks to the
principal, Ms. Priyanka Bhatkoti for her encouragement and
all the facilities which were provided to complete the practical
file. I sincerely appreciate her efforts for taking me into her
fold for which I shall remain forever in debt.
I extend my heartiest thanks to Ms. Bhumika Dwivedi, our
Computer Science teacher, who guided me towards the
successful completion of this practical file. I take this
opportunity to express my sincere gratitude for her immense
guidance, constant encouragement, and motivation which has
sustained my efforts at all stages of this practical file.
I can't forget to offer my sincere thanks to my parents, team-
mates and friends who help me carry out this practical file
successfully.
Certificate
Name: Ronish Singh Class: XII-B
Roll No: 30
This is certified to be the bonafide work of the student
in the Computer Science Practical File during the
academic year 2022 – 2023
________________
Signature of Teacher
________________ ________________
Signature of Examiner Signature of
Principal
Date: ___________
S. No. Topic Date Sign
PYTHON
1. Searching element in a list and displaying
frequency and location 12-04-22
2. Program to find sum of elements of list
recursively 19-04-22
3. Program to pass list to a function and double
the odd values and half even values of a list 26-04-22
and display list element after changing
4. Input n numbers in tuple and pass it to
function to count how many even and odd 05-05-22
numbers are entered
5. Program to function for key and value, and
update value at that key in dictionary entered 05-05-22
by user
6. Pass a string to a function and count how
many vowels are present in the string 12-05-22
7. Program that generates random number
between 1 and 6 12-05-22
8. Program to read a string, count and display
the number of alphabets, digits, spaces and 19-05-22
special characters in the string.
9. Python function to covert decimal to binary.
19-05-22
10 Python function to find whether an entered
number is perfect or not. 26-05-22
11. Python function to check if the entered
number is Armstrong or not. 26-05-22
12. A menu-driven python program to implement
stack operation. 12-07-22
13. Python program to check whether a string is a
palindrome or not using stack. 12-07-22
14. Write a python program using function
PUSH(Arr), where Arr is a list of numbers.
From this list push all numbers divisible by 5
or 7 into a stack implemented by using a list. 19-07-22
Display the stack if it has at least one
element, otherwise display appropriate error
message.
15. Program to read and display a text file
content line by line with each word separated 15-08-22
by #
16. Program to remove all the lines that contain
character ‘a’ in a text file and write it to 15-08-22
another file.
17. Program to read characters one by one from
keyboard, all lower-case characters to be
stored in file ‘lower’ and all uppercase in file 22-08-22
‘upper’ while other characters should be
stored in file ‘others’
18. Create a CSV file by entering user-id and
password, read and search the password for
22-08-22
given user- id.
19. Create a binary file with roll no. and marks.
Search for a given roll number and update the 05-09-22
marks as per given by user.
20. Write a function RevText() to read a text file
“ Story.txt” and print only word starting with
‘I’ in reverse order . Example: If value in text 05-09-22
file is: INDIA IS MY COUNTRY Output
will be: AIDNI SI MY COUNTRY
21. ABC infotech Pvt Ltd. needs to create a
database for their digital account. Develop an
interface that provides front-end interaction
with Python. Write Python program with
separate user defined functions to perform the
following tasks: 08-11-22
1. Create a databse abc_office
2. Create a table Employees with fields
EmpId, Name, Age, Gender and Salary
3.Insert data into table
22. For ABC infotech create a function to
connect to the database and retrieves all
records and displays total number of records. 05-11-22
23. Write a program to read and fetch all the
records from employees table having salary
more than 30000. 05-11-22
24. Write a program to increase the salary by 5%
where employee if is 104. 05-11-22
MYSQL
1. Write SQL query to create and show a
database Employee. 04-10-22
2. Write SQL query to open database Employee.
04-10-22
3. Write SQL query to create following Table
name empl. 04-10-22
4. Write SQL query to show the structure of
table. 04-10-22
5. Write SQL query to Insert 10 records.
04-10-22
6. Write SQL query to display all the records
from table empl 11-10-22
7. Write SQL query to display EmpNo and
EName of all employees from the table empl 11-10-22
8. Display the details of employees whose name
have only four letters 11-10-22
9. Display the details of all employee whose
annual salary is between 25000 to 40000 11-10-22
10. Display name, job title and salary of
employee who do not have manager 11-10-22
11. Display the name of employee whose name
contains A as third letter 18-10-22
12. Display the name of employee whose name
contains L as any letter 18-10-22
13. Display the name of departments. Each
department should be displayed once 18-10-22
14. Queries for Aggregate functions- SUM( ),
AVG( ), MIN( ), MAX( ), COUNT( ) 25-10-22
15. Display the names of employees in lowercase
and uppercase 25-10-22
16. Display the position of the string 'LE' in the
field job of table empl 25-10-22
17. Display all data of empl according to salary
arranged in ascending order 01-11-22
18. Display department no., job and no. of
employees in a particular job grouped by 01-11-22
department no., job from empl
19. Display the jobs where the number of
employees is less than 3 01-11-22
Practical-1
Searching element in a list and displaying frequency
and location
Practical-2
Program to find sum of elements of list recursively
Program to pass list to a function and double the odd values and half even
values of a list and display list element after changing
Practical-3
Input n numbers in tuple and pass it to function to count how many even and
odd numbers are entered
Practical-4
Practical-5
Program to function for key and value, and update value at that key in
dictionary entered by user
Pass a string to a function and count how many vowels are present in the string
Practical-6
Program that generates random number between 1 and 6
Practical-7
Practical-8
Program to read a string, count and display the number of alphabets, digits,
spaces and special characters in the string
Practical-9
Python function to covert decimal to binary
Practical-10
Python function to find whether an entered number is perfect or not
Practical-11
Python function to check if the entered number is Armstrong or not
Practical-12
A menu-driven python program to implement stack operation
Practical-13
Python program to check whether a string is a palindrome or not using stack
Practical-14
Write a python program using function PUSH(Arr), where Arr is a list of
numbers. From this list push all numbers divisible by 5 or 7 into a stack
implemented by using a list. Display the stack if it has at least one element,
otherwise display appropriate error message.
Program to remove all the lines that contain character ‘a’ in a text file and write
it to another file.
Practical-15
Practical-16
Program to read and display a text file content line by line with each word
separated by #
Practical-17
Program to read characters one by one from keyboard, all lower-case characters
to be stored in file ‘lower’ and all uppercase in file ‘upper’ while other
characters should be stored in file ‘others’
Practical-18
Create a CSV file by entering user-id and password, read and search the
password for given user- id.
Practical-19
Create a binary file with roll no. and marks. Search for a given roll number and
update the marks as per given by user
Practical-20
Write a function RevText() to read a text file “ Story.txt” and print only word
starting with ‘I’ in reverse order . Example: If value in text file is: INDIA IS
MY COUNTRY Output will be: AIDNI SI MY COUNTRY
Practical-21
ABC infotech Pvt Ltd. Needs to create a database for their digital account.
Develop an interface that provides front-end interaction with Python. Write
Python program with separate user defined functions to perform the following
tasks:
1.Create a database abc_office
2.Create a table Employees with fields EmpId, Name, Age, Gender, and Salary
3.Insert data into table
Practical-22
For ABC infotech create a function to connect to the database and retrieve all
records and display total number of records
Practical-23
Write a program to read and fetch all the records from employees table having
salary more than 30000.
Practical-24
Write a program to increase the salary by 5% where employee id is 104.
SQL Practicals
Practical-1
Write SQL query to create and show a database Employee.
Practical-2
Write SQL query to open database Employee.
Practical-3
Write SQL query to create following Table name empl
Practical-4
Write SQL query to show the structure of the table.
Practical-5
Write SQL query to insert 10 records
Practical-6
Write SQL query to display all records from table empl.
Practical-7
Write SqL query to display EmpNo and Ename of all employees from the table
Practical-8
Display the details of employees whose name have only four letters
Practical-9
Display the details of all employees whose annual salary is between 25000 to
40000
Practical-10
Display name,job title and salary of employee who do not have manager
Practical-11
Display the name of employee whose name contains A as third letter
Practical-12
Display the name of employee whose name contains L as any letter
Practical-13
Display the name of departments. Each department should be displayed once
Practial-14
Queries for Aggregate functions- SUM(),AVG(),MIN(),MAX(),COUNT()
Practical-15
Display the names of employees in lowercase and uppercase
Practical-16
Display the position of the string ‘LE’ in the field job of table empl
Practical-17
Display all data of empl according to salary arrange in ascending order
Practical-18
Display department no., job and no. of employees in a particular job grouped by
department no., from empl
Practical-19
Display the jobs where the number of employees is less than 3
