Certificate
This is to certify that MR. SOURABH of XII class,
Royal Public Senior Secondary School, Wazirpur has
completed this project file under my supervision.
He has taken keen interest and shown utmost
sincerity in completion of this pratical file. He has
successfully completed the pratical file of Computer
Science up to my satisfaction.
Signature of Internal Signature of External
Examiner Examiner
ACKNOWLEDGEMENT
I I would like to express my gratitude to my pratical file guide
Mrs. Anita Mishra for guiding me immensely through the
course of the pratical file. She always evinced a keen interest in
my work. Her constructive advice and constant motivation have
been responsible for the successful completion of this pratical
file. My sincere thanks go to Dr. Vijay Singh Chauhan, our
Principal sir, for his coordination in extending every possible
support for the completion of this pratical file.
I also thank my parents for their motivation and support. I must
thank to my classmates for their timely help and support for the
compilation of this pratical file.
Last but not the least, I would like to thank those who had
helped directly or indirectly towards the completion of this
pratical file.
SUBMISSION
This report is submitted as a part of a pratical examination
included in curriculum of CBSE for all India Senior Secondary
Examination to be held in the year 2025-26.
[Link] PROGRAMMS REMARKS
1. WAP a program to read a text file
line by line and display each word
separated by
“#”.
2. WAP to read a text file and display
the number of vowels, consonants,
uppercase and lowercase
characters in the file.
3. WAP to remove all the lines that
contain the character “a” in a file
and write it to another file.
4. WAP to create a binary file with
name and roll no., search for a
given roll no. and display the name
(if not found display appropriate
message).
5. WAP to create a binary file with roll
no., name and marks, input a roll
no. and update the marks.
6. WAP to create a CSV file by
entering user id and password, read
and search the password for the
given user id.
7. WAP of random number generator
that generate random numbers
between 1 and 6 (simulates a dice).
8. WAP to calculate simple interest
using function INSERT () that can
receive principal amount, time, rate
and return the simple interest. Do
specific default value for rate and
time as 10% and five years
respectively.
9. WAP a program to find the factorial
of a given number using function.
10. WAP to find the area and perimeter
of circle using user defined module.
11. WAP to read a text file ‘[Link]’ and
display those words which having
exactly four characters.
12. WAP for implementation of stack
using list.
13. WAP to implement a stack for these
book details (book number, book
name) implement push, pop and
display operation.
14. WAP to create a table EMPLOYEE
with the following structure and
display the structure after creation.
15. WAP to insert five records into the
table EMPLOYEE and display the
table contents after insertion.
16. WAP to display the details of
employee in ascending order of
their salary.
17. WAP to connect with database,
insert record entered by the user in
a table and display all the records.
18. WAP to search the record in mysql
table using python, if not found
display appropriate message.
19. WAP to update the record in mysql
table using python, if not found
display appropriate message.
20. WAP to update the record in mysql
table using python, if not found
display appropriate message.
1. WAP a program to read a text file line by
line and display each word separated by “#”.
SOURCE CODE:-
OUTPUT:-
SOURCE FILE:-
2. WAP to read a text file and display the
number of vowels, consonants, uppercase
and lowercase characters in the file.
SOURCE CODE:-
OUTPUT:-
SOURCE FILE:-
3. WAP to remove all the lines that contain
the character “a” in a file and write it to
another file.
SOURCE CODE:-
OUTPUT:-
BEFORE
AFTER
4. WAP to create a binary file with name
and roll no., search for a given roll no. and
display the name (if not found display
appropriate message)
SOURCE CODE:-
OUTPUT:-
5. WAP to create a binary file with roll no.,
name and marks, input a roll no. and
update the marks.
SOURCE CODE:-
Output:-
6. WAP to create a CSV file by entering
user id and password, read and search the
password for the given user id.
Source code:-
OUTPUT:-
7. WAP of random number generator that
generate random numbers between 1 and
6 (simulates a dice).
SOURCE CODE:-
OUTPUT:-
8. WAP to calculate simple interest using
function INSERT () that can receive
principal amount, time, rate and return
the simple interest. Do specific default
value for rate and time as 10% and five
years respectively.
SOURCE CODE:-
OUTPUT:-
9. WAP a program to find the factorial of a
given number using function.
SOURCE CODE:-
OUTPUT:-
[Link] to find the area and perimeter of
circle using user defined module.
Source code:-
Output:-
Module used in this program-
11. WAP to read a text file ‘[Link]’ and
display those words which having exactly
four characters.
SOURCE CODE:-
OUTPUT:-
12. WAP for implementation of stack using
list.
SOURCE CODE:-
OUTPUT:-
13. WAP to implement a stack for these book
details (book number, book name)
implement push, pop and display operation.
SOURCE CODE:-
OUTPUT:-
[Link] to create a table EMPLOYEE with the
following structure and display the structure
after creation.
SOURCE CODE:-
OUTPUT:-
15. WAP to insert five records into the table
EMPLOYEE and display the table contents
after insertion.
SOURCE CODE:-
OUTPUT:-
16. WAP to display the details of employee in
ascending order of their salary.
Source code:-
Output :-
17. WAP to connect with database, insert
record entered by the user in a table and
display all the records.
Source code:-
Output:-
18. WAP to search the record in mysql table
using python,if not found display appropriate
message.
Source code:-
Output:-
19. WAP to update the record in mysql table
using python, if not found display
appropriate message.
Source code:-
Output:-
Checking of updation:-
20. WAP a program to delete the particular
record in mysql table using python.
Source code:-
Output:-
Checking of updation:-