’S SR. SEC.
S
UL CH
PA
O
OL
ST.
SESSION: 2025-26
COMPUTER SCIENCE
SUBMITTED BY- SUBMITTED TO-
ROSER PRINCE MR. NAGENDRA SIR
CLASS-12TH C
ROLL NO-27
Acknowledgement
I would like to express my special
thanks of gratitude to my Computer
Science teacher “Mr. Nagendra Sir”
for their able guidance and support in
completing my project.
I would also like to extend my
gratitude to the Principal mam “Ms.
Sylvia Das” for providing me all the
facility that was required.
Roser Prince
12th C
This is to certify that Roser prince
student of class 12th C has
completed his project under my
guidance. The project is submitted
for evaluation as a part of CBSE
curriculum of session 2025-26.
Teacher’s Signature
__________________
Q1. Write a program to display Fibonacci series up to “N” numbers using User
Define Function.
CODE →
OUTPUT →
Q2. Write a menu driven python program to find the factorial and sum of list of numbers
using function. Using User Define Function.
CODE →
OUTPUT →
Q3. Write a python program to implement the mathematical function to find:
i. Square of a number
ii. To find Log of a number (log10)
iii. To find the square root of [Link] User Define Function
CODE →
OUTPUT →
Q4. Write a python program to generate random numbers between 1 to 6 to
simulate the dice. Using User Define Function.
CODE →
OUTPUT →
Q5. Write a program to check whether the string is Palindrome or not without using
Slicing method. Using User Define Function.
CODE →
OUTPUT →
Q6. Write a python program to read a text file “[Link]” and display the number of
vowels, consonant, lower case, upper case, special characters in a file. Using User
Define Function.
FILE→
CODE →
OUTPUT →
Q7. Python program to read the text file line by line and display each word
separated by #. Using User Define Function.
FILE→
CODE →
OUTPUT →
Q8. Write a python program to read line from a text line “[Link]” and copy
those lines into another file which are starting with an Alphabet “a” and “A”. Using
User Define Function.
INPUT FILE→
CODE →
OUTPUT FILE→
Q9. Write a function count words in python that counts the numbers of words
ending with the digits in a text file “[Link]”. Using User Define Function.
FILE→
CODE →
OUTPUT →
Q10. Write a program in python to write some records in a binary file “[Link]”
and search the record. The student record contains admission number, name,
class, roll no and percentage. Searching is done for a specific admission number.
Using User Define Function.
CODE →
OUTPUT →
Q11. Write a program in python to update the record in a binary file “[Link]”
and search the record. The student record contains admission number, name,
class, roll no and percentage. Updating is done in percentage on a specific
admission number. Using User Define Function.
CODE →
OUTPUT →
Q12. Write a program in python to append the record in a binary file “[Link]”
The student record contains admission number, name, class, roll no and
percentage. Using User Define Function.
CODE →
OUTPUT →
Q13. Write a program to insert and delete the record of a student in a binary file
“[Link]” The student record contains admission number, name, class, roll no
and percentage. Using User Define Function.
CODE →
OUTPUT →
INSERTING RECORD→
AFTER INSERTING RECORD→
DELETING RECORD→
AFTER DELETING RECORD→
Q14. Write a program to create a CSV file to store some records of an employee
contain employee number, name, salary and display them. Using User Define
Function.
CODE →
OUTPUT →
Q15. Write a program to create a CSV file to store some records of an employee
contain employee number, name, salary and search for a specific record. Also
display message “Found and not Found”. Using User Define Function.
CODE →
OUTPUT →
Q16. Write a python program to implement stack using list data structure. Using
User Define Function.
CODE →
OUTPUT →
Q17. Write a python program to implement connectivity with My SQL to insert
record in employee table and display the records. Using User Define Function.
CODE→
OUTPUT→
Q18. Write a python program to integrate MY SQL with python to search an
employee using EMPID and display the record if present in already exiting table
EMP, if not display appropriate message. Using User Define Function.
CODE→
OUTPUT→
Q19. Write a python program to integrate My SQL with python to search an
employee using EMPID and update the salary of an Employee if present in already
exiting table EMP, if not display appropriate message. Using User Define Function.
OUTPUT→
BEFORE UPDATING →
AFTER UPDATING →
Q20. Write a SQL command to create the table EMP with code, name, department,
designation, experience, gender, salary, city with appropriate data types. Use
constraints to make code as primary key salary between 20000 to 50000 and
default designation as “Worker”. Show output.
COMMAND→
OUTPUT →
Q21. Write a SQL command to insert some records in the above table of EMP. Show
output.
COMMAND→
OUTPUT →
Q22. Write a SQL command to display the records of employee belonging to sales
department and getting salary between 25000 to 35000. Show output.
COMMAND→
OUTPUT →
Q23. Write a SQL command to arrange the records of male employee in ascending
order of salary of employees having experience more than 20 years. Show output.
COMMAND→
OUTPUT →
Q24. Write a SQL command to display the number of employees in each
department in the above table EMP. Show output.
COMMAND→
OUTPUT →
Q25. Write a SQL command to display the minimum and the maximum salary of
each department. Show output.
COMMAND→
OUTPUT →
Q26. Write a SQL command to add a new column “mobile number” in the above
table of EMP. Show output.
COMMAND→
OUTPUT →
Q27. Write a SQL command to update the record of all employee by increasing their
salary by 10%. Show output.
COMMAND→
OUTPUT →
Q28. Write a SQL command to delete the record of employees with experience less
than 5 years. Show output.
COMMAND→
OUTPUT →
Q29. Write a SQL command to create another table “Employee duplicate” from the
table EMP containing all fields and all records of table EMP. Show output.
COMMAND→
OUTPUT →
Q30. Write a command to remove the table 'Employee duplicate' from database.
Show output.
COMMAND→
OUTPUT →