CLASS 12 CS PRACTICAL DETAILS

Download as pdf or txt
Download as pdf or txt
You are on page 1of 2

TECHNO INDIA GROUP PUBLIC SCHOOL, KONNAGAR

STD-XII (2024-25)
SUBJECT- COMPUTER SCIENCE
PRACTICAL COPY PROGRAM LIST

DATE OF ASSIGNMENT OF PROJECT- 11/05/2024


DATE OF SUBMISSION OF PROJECT- 02/08/2024

PYTHON PROGRAMS
1 Write a python program to print factorial of given number.
2 Write a python program to check if the entered number is Armstrong number or
not.
3 Write a python program to read a text file line by line and display each word
separated by a #.
4 Write a python program to print Fibonacci series upto n terms
5 Write a python program to print factors of a given number excluding 1 & itself.
6 Read a text file and display the number of vowels/consonants/uppercase/lowercase
characters in the file.
7 Write a random number generator that generates random numbers between 1 and
6 (Simulates a dice).
8 Write a python program to check whether a string is palindrome or not using stack.
9 Remove all the lines that contain the character 'a' in a file and write it to another
file.
10 Write a python program to remove all lines that contains the character ‘a’ in a file
& write it to another file.
11 Write a Python program to implement a stack using list.
12 Create a binary file with name and roll number. Search for a given roll number and
display the name, if not found display appropriate message.
13 Write a python program to check whether a string is palindrome or not.
14 Create a CSV file by entering user-id and password, read and search the password
for given userid.
15 Create a binary file with roll number, name and marks. Input a roll number and
update the marks.
SQL QUERIES
16 Create a database UNIVERSITY & create table within it.
17 Create a student table and insert data. Implement the following SQL commands on
the STUDENT table:
ALTER table to add new attributes / modify data type / drop attribute
UPDATE table to modify data
18 ORDER By to display data in ascending / descending order
DELETE to remove tuple(s)
GROUP BY and find the min, max, sum, count and average
19 DELETE database & remove all tables from Database
PYTHON SQL CONNECTIVITY
20 Write a program to create a database named SCHOOL through MySQL-Python
connectivity.
21 Write a program to insert data given below in STUDENT table with MySQL-Python
connectivity.
22 Write a program to insert data given below in TEACHER table with MySQL-Python
connectivity.
23 Write a program to fetch all the records from STUDENT table & TEACHER table with
MySQL-Python connectivity.
24 Write a program to fetch all the records from STUDENT table who are reading
either XI or XII with MySQL-Python connectivity.
25 Write a program to fetch all the records from TEACHER table who are teaching
either XI or XII with MySQL-Python connectivity.

You might also like