DELHI PUBLIC SCHOOL, KALYANPUR, KANPUR
SESSION – 2024–25
COMPUTER SCIENCE
PRACTICAL FILE
CLASS XII
SUBMITTED TO :
HIMANSHU SHUKLA SIR
SUBMITTED BY :
Sarthak Chandra
Class XII – S3
Roll No. 31
ACKNOWLEDGEMENT
I would like to convey my heartfelt thanks to Mr. Himanshu Shukla, my faculty of Computer Science, who
provided valuable guidance for the completion of this Practical File. His constant support and
encouragement helped me understand important concepts and successfully complete this work.
Signature of Subject Teacher
Sarthak Chandra
Class XII – S3
Roll No. 31
Signature of Principal
PYTHON PROGRAMS
Program 1 to 30: Referenced Python programs include pattern printing, list/tuple/dictionary operations,
functions, recursion, and file handling. All programs are arranged sequentially and written using standard
Python syntax.
for i in range(1, 6):
for j in range(i):
print("*", end=" ")
print()
SQL PROGRAMS
CREATE TABLE Student(
RollNo INT PRIMARY KEY,
Name VARCHAR(50),
Class VARCHAR(5),
Percentage FLOAT
);
INSERT INTO Student VALUES (1, 'Akshay', '12A', 92.5);
All SQL programs from CREATE, INSERT, SELECT, AGGREGATE FUNCTIONS, GROUP BY, UPDATE
and DELETE are arranged sequentially with proper headings.