Computer Science Practical File
Submitted By:- Tarun Singh SubmittedTo:Geetanjali.
Roll No. :- 31
Board Roll no. :-17617488
PRACTICAL FILE – XII (COMPUTER SCIENCE) Page 1 / 36
CERTIFICATE
CLASS: XII-B YEAR: 2024-2025
This is to certify that Investigatory Project is successfully completed by
Tarun Singh of Class: XII, Division: B
Roll no.: 31 for the academic year 2024-2025 in the School
Computer lab.
Head Teacher External Internal Examiner
Signature: Examiner (Subject Teacher)
Date: / / 25 Department of: COMPUTER SCI.
Principal
PROGRAM 1
CREATING A MENU DRIVEN PROGRAM TO PERFORM ARITHMETIC OPERATIONS
OUTPUT
PROGRAM 2
CREATING A PYTHON PROGRAM TO DISPLAY FIBONACCI SERIES
OUTPUT
PROGRAM3
CREATING A MENU DRIVEN PROGRAM TO FIND FACTORIAL AND SUM OF LIST OF NUMBERS USING
FUNCTION.
OUTPUT
PROGRAM 4
CREATING A PYTHON PROGRAM TO IMPLEMENT RETURNING VALUE(S) FROM FUNCTION
OUTPUT
PROGRAM 5
CREATING A PYTHON PROGRAM TO IMPLEMENT MATHEMATICAL FUNCTIONS
OUTPUT
PROGRAM 6
CREATING A PYTHON PROGRAM TO GENERATE RANDOM NUMBER BETWEEN 1 TO 6
OUTPUT
PROGRAM 7
CREATING A PYTHON PROGRAM TO READ A TEXTFILE LINE BY LINE AND DISPLAY EACH WORD
SEPARATED BY '#'
OUTPUT
Story.txt:
PROGRAM 8
CREATING A PYTHON PROGRAM TO READ A TEXT FILE AND DISPLAY THENUMBEROF
VOWELS/CONSONANTS/LOWERCASE/UPPER CASECHARACTERS.
OUTPUT
Story.txt:
PROGRAM 9
CREATING PYTHON PROGRAM TO DISPLAY SHORT WORDS FROM A TEXTFILE
OUTPUT
Poem.txt:
PythonExecutedProgramOutput:
PROGRAM 10
CREATING A PYTHON PROGRAM TO COPY PARTICULAR LINES OF A TEXTFILE INTO
AN ANOTHER TEXT FILE
OUTPUT
Sample.txt:
PythonExecutedProgramOutput:
New.txt:
PROGRAM 11
CREATING A PYTHON PROGRAM TO CREATE AND SEARCH RECORDS IN BINARY FILE
OUTPUT
PROGRAM 12
CREATING A PYTHON PROGRAM TO CREATE AND UPDATE/MODIFY RECORDS IN
BINARY FILE
OUTPUT
PROGRAM 13
CREATING A PYTHON PROGRAM TO CREATE AND SEARCH EMPLOYEE’S RECORD IN CSV FILE.
OUTPUT
PROGRAM 14
CREATING A PYTHON PROGRAM TO IMPLEMENT STACK OPERATIONS(LIST)
OUTPUT
PROGRAM 15
CREATING A PYTHON PROGRAM TO IMPLEMENT STACK OPERATIONS(Dictionary)
OUTPUT
PROGRAM 16
CREATING A PYTHON PROGRAM TO INTEGRATE MYSQL WITH PYTHON
(CREATING DATABASE AND TABLE)
OUTPUT
PROGRAM 17
CREATING A PYTHON PROGRAM TO INTEGRATE MYSQL WITH PYTHON
(INSERTING RECORDS AND DISPLAYING RECORDS)
OUTPUT
PROGRAM 18
CREATING A PYTHON PROGRAM TO INTEGRATE MYSQL WITH PYTHON (SEARCHING AND
DISPLAYING RECORDS)
OUTPUT
PROGRAM 19
CREATING A PYTHON PROGRAM TO INTEGRATE MYSQL WITH PYTHON (UPDATING
RECORDS)
OUTPUT
PROGRAM 20
Perform all the operations with reference to table ‘Employee’ through
MySQL-Python connectivity.
Solution:
import MySQLdb
# Using connect method to connect database
db1 = MySQLdb.connect("localhost","root","","TESTDB" )#
using cursor() method for preparing cursor
cursor = db1.cursor()
# Preparing SQL statement to create EMP table
sql = "CREATE TABLE EMP(empno integer primary key,ename varchar(25) not null,salary
float);"
cursor.execute(sql)
# disconnect from serverdb1.close()
Inserting a record in ‘emp’
import MySQLdb
db1 = MySQLdb.connect("localhost","root","","TESTDB"
)cursor = db1.cursor()
# Prepareing SQL statement to insert one record with the given
valuessql = "INSERT INTO EMP VALUES (1,'ANIL
KUMAR',86000);"
try:
cursor.execute(sql)
db1.commit()
except:
db1.rollback()
db1.close()
Fetching all the records from EMP table having salary more than 70000.
import MySQLdb
db1 = MySQLdb.connect("localhost","root","","TESTDB"
)cursor = db1.cursor()
sql = "SELECT * FROM EMP WHERE SALARY > 70000;"
try:
cursor.execute(sql)
#using fetchall() function to fetch all records from the table EMP and store in
resultset
resultset =
cursor.fetchall()for row in
resultset:
print
(row)except:
print ("Error: unable to fetch data")
db1.close()
Updating record(s) of the table using UPDATE
import MySQLdb
db1 = MySQLdb.connect("localhost","root","","TESTDB"
)cursor = db1.cursor()
#Preparing SQL statement to increase salary of all employees whose salary is less
than 80000
sql = "UPDATE EMP SET salary = salary +1000 WHERE
salary<80000;"try:
cursor.execute(sql)
db1.commit()
except:
db1.rollback()
db1.close()
Deleting record(s) from table using DELETE
import MySQLdb
db1 = MySQLdb.connect("localhost","root","","TESTDB" )cursor
= db1.cursor()
sal=int(input("Enter salary whose record to be deleted : ")) #Preparing
SQL statement to delete records as per given conditionsql = "DELETE
FROM EMP WHERE salary =sal”
try:
cursor.execute(sql)
print(cursor.rowcount, end=" record(s) deleted ")
db1.commit()
except:
db1.rollback()
db1.close()
Output
>>> Enter salary whose record to be deleted: 800001
record(s) deleted
>>>
