AISSCE PRACTICAL EXAMINATION 2023-24

SUBJECT – COMPUTER SCIENCE (083)

CLASS XII
(Set A)
Duration:- 3 HOURS Total Marks 30
______________________________________________________________________________
_______
Q1. Write a Python program to implement Stack using a list data-structure, to perform the following
operations: (i) To Push an object containing Doc_ID and Doc_name of doctors who specialize in "ENT"
to the stack.
(ii) To Pop the objects from the stack and display them.
(iii) To display the elements of the stack (after performing PUSH or POP) [8]
AIM:
Q2. Consider the tables Product and write SQL commands for questions (1) to (4). [4]
TABLE : PRODUCTS
P_ID PRODUCTNAME MANUFACTURER PRICE
RP01 ROSE POWDER LAK 40
BW05 BODY WASH HIM 45
MC01 MOISTURIZING CREAM HIM 75
CO06 CONDITIONER REV 120
BW12 BODY WASH ORI 95

[ QUERIES SHOULD BE EXECUTED BEFORE SELECT COMMAND

mysql>create database practicalA;

mysql>use practicalA;
mysql>create table products(P_ID VARCHAR PRIMARY KEY, PRODUCTNAME VARCHAR(25),
MANUFACTURER VARCHAR(5),PRICE INT));
mysql>insert into products values(“RP01”,”ROSE POWDER”,”LAK”,40);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]
 1. Display product Id, product name, manufacturer for Body wash products.
SELECT
P_ID, PRODUCTNAME,MANUFACTURER FROM PRODUCTS
WHERE PRODUCTNAME=”BODY WASH”;
2. To increase the price of Conditioner by 20
UPDATE PRODUCTS SET PRICE=PRICE+20 WHERE PRODUCTNAME=”CONDITIONER”;
3. List the average price of products of each manufacturer.
SELECT MANUFACTURER,AVG(PRICE) FROM PRODUCTS GROUP BY MANUFACTURER;
4. Remove details of product which are manufactured by the manufacturer ORI.
DELETE FROM PRODUCTS WHERE MANUFACTURER=”ORI”;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(Set B)
Duration:- 3 HOURS Total Marks
30
______________________________________________________________________________
______Q1. Write a Python program Create a CSV file to store Empno, Name, Salary and search
any Empno and display Name, Salary and if not found display appropriate message.
[8]

Result:
Thus the above python program has been executed and the output is verified successfully.
Q2. Consider the tables Clients and write SQL commands for questions (1) to (4). [4]

TABLE : CLIENTS
C_ID CLIENTNAME CITY P_ID
1 COSMETIC SHOP KOLKATA BW05
6 TOTAL HEALTH MUMBAI MC01
12 LIVE LIFE KOLKATA CO06
15 PRETTY WOMAN KOLKATA BW12
16 DREAMS BANGALORE RP01

[
Queries to execute before the select command:

mysql> create database practicalB;

mysql>use practicalB;
mysql>create table clients(C_ID INT PRIMARY KEY,CLIENTNAME VARCHAR(25),CITY
VARCHAR(29), P_ID VARCHAR(10));
mysql>insert into clients values(1,”COSMETIC SHOP”,”KOLKATA”,”BW05”);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]

1. Display client name, city for the client id 15.

SELECT CLIENTNAME, CITY FROM CLIENTS WHERE C_ID=15.
2. Display the client name in ascending order.
SELECT CLIENTNAME FROM CLIENTS ORDER BY CLIENTNAME.
3. Change city of client 12 into DELHI.
UPDATE CLIENTS SET CITY=”DELHI” WHERE C_ID=12;
4. Remove details of clients who are from the city MUMBAI.
DELETE FROM CLIENTS WHERE CITY=”MUMBAI”;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(SAMPLE C)
Duration:- 3 HOURS Total
Marks 30
______________________________________________________________________________
_______
Q1. Create a table EMP with the following specifications and constraints:
Field Type of data Size Constraint
Eid Integer 4 Primary key
Name varchar 25 Not null
Gender Varchar 5
Salary float 10,2
Add 5 records to the above table with the following data in mysql
Eid Name Gender Salary
1 SRIJAN M 50000
2 PRIYA F 40000
3 HEMANTH M 25000
4 VEERA M 30000
5 MANI M 20000
To write a Python Program to integrate MYSQL with Python to search an Employee
using EMPID and display the record if present in an already existing table EMP, if not
display the appropriate message.
[8]

[
QUERIES TO DO IN MYSQL EDITOR BEFORE THE PYTHON CODE GIVEN BELOW:

mysql>create database practicalC;

mysql>use practicalC;
mysql>create table EMP(Eid int primary key,Name varchar(25) not null ,Gender
varchar(1),salary float(10,2));
mysql>insert into emp values(1,”SRIJAN”,”M”,50000);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]
source code:
import mysql.connector
con=mysql.connector.connect(host=”localhost”,username=”root”,password=”1234”,d
atabase=”practicalC”)

Q2. Consider the table Designation and write SQL commands for questions (1) to (4). [4]

TABLE : DESIGNATION

W_ID SALARY BENEFIT DESIGNATION

102 75000 15000 MANAGER
200 75000 12500 MANAGER
210 35000 10000 CLERK
144 34000 10000 CLERK
450 28000 7500 SALESMAN
105 85000 25000 DIRECTOR
[
QUERIES TO EXECUTE BEFORE THE SELECT COMMAND:

mysql>use practicalC;
 mysql>create table designation (W_ID INT PRIMARY KEY,SALARY INT,BENEFIT
INT,DESIGNATION VARCHAR(20));
mysql>insert into designation values(102,75000,15000,”MANAGER”);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]
1. Display w_id and salary of all the Clerks.
SELECT W_ID,SALARY FROM DESIGNATION WHERE DESIGNATION=”CLERK”;
2. Display the maximum salary and designation of employees designation wise
SELECT MAX(SALARY),DESIGNATION FROM DESIGNATION GROUP BY DESIGNATION;
3. Decrease the benefits of Salesman and Managers by 1000.
UPDATE DESIGNATION SET SALARY=SALARY-1000 WHERE DESIGNATION
IN(“MANAGER”,” SALESMAN”);
4. Display salary details of worker those who getting benefits in the range of 10000 to
15000.
Select * from designation where benefit between 10000 and 15000;
Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(Set D)
Duration:- 3 HOURS Total Marks
30
______________________________________________________________________________
_______
Q1. Create a table EMP with the following specifications and constraints:
Field Type of data Size Constraint
Eid Integer 4 Primary key
Name varchar 25 Not null
Gender Varchar 5
Salary float 10,2
Add 5 records to the above table with the following data in mysql
Eid Name Gender Salary
1 SRIJAN M 50000
2 PRIYA F 40000
3 HEMANTH M 25000
4 VEERA M 30000
5 MANI M 20000

Write a Python Program to integrate MYSQL with Python for inserting the records given to
Emp table and display the records. [8]
[
QUERIES TO DO IN MYSQL EDITOR BEFORE THE PYTHON CODE GIVEN BELOW:

mysql>create database practicalD;

mysql>use practicalD;
mysql>create table EMP(Eid int primary key,Name varchar(25) not null ,Gender
varchar(1),salary float(10,2));

]
Source Code
import mysql.connector
con=mysql.connector.connect(host=”localhost”,username=”root”,password=”1234”,
database=”practicalD”)
Q2. Consider the following table STUDENT and Write SQL commands for questions (1) to (3)
And Output for (4) and (5) [4]

ROLL_N STD_NAME AGE DEPT DATEOFADM FEE GENDER

O

1 PANKAJ 24 COMPUTER 1997/01/10 120 M

2 SHALINI 21 HISTORY 1998/03/24 200 F

3 SANJAY 22 HINDI 1996/12/12 300 M

4 SUDHA 25 HISTORY 1999/07/01 400 F

5 RAKESH 22 HINDI 1997/09/05 250 M

[ Queries to execute before the select command.

mysql>use practicalD;
mysql>create table student(ROLL_NO INT PRIMARY KEY,STD_NAME VARCHAR(25),AGE
INT,DEPT VARCHAR(20),DATEOFADM DATE,FEE INT,GENDER CHAR(1));
mysql>insert into student values(1,”PANKAJ”,24,”COMPUTER”,”1997/01/10”,120,”M”);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

1. Display all the details about students in the History department.

SELECT * FROM STUDENT WHERE DEPT=”HISTORY”;
2. Display the name of female students who are in the Hindi department.
SELECT STD_NAME,DEPT FROM STUDENT WHERE DEPT=”HINDI” AND GENDER=”F”
3. Display average fees department wise.
SELECT DEPT,AVG(FEE) FROM STUDENT GROUP BY DEPT;
4. Decrease the fees of students who are in history department by 50 .
UPDATE STUDENT SET FEE=FEE -50 WHERE DEPT=”HISTORY”;
Q.3 Report File [8]

Q.4 Project File [7]

Q.5 Viv [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(SAMPLE E)
Duration:- 3 HOURS Total Marks 30
______________________________________________________________________________
Q1.To write a Python Program to read a text file "Story.txt" and displays the number of
Vowels/ Consonants/ Lowercase / Uppercase/characters in the file.
[ STEPS TO DO BEFORE TYPING THE PYTHON CODE:
create a text file story by using notepad in D: drive . file can have any text.
the python file also should be stored in the same drive.

]
Q2. Consider the table Workers and write SQL commands for questions (1) to (4). [4]

TABLE : WORKERS

W_ID FIRSTNAME LASTNAME ADDRESS CITY

102 SAM TONERS 33 ELM ST PARIS
105 SARAH ACKERMAN 440 U S NEW YORK
144 MANILA SENGUPTA 24 FRIENDS ST HOWARD
200 GEORGE SMITH 83 FIRST ST WASHINGTON
210 ROBERT SAMUEL 9 FIFTH CROSS BOSTON
450 PAT THOMSON 11 RED ROAD PARIS

[ QUERIES TO EXECUTE BEFORE SELECT COMMAND:

mysql>CREATE DATABASE PRACTICALE;

mysql>use practicalE;

mysql>create table workers(W_ID INT PRIMARY KEY,FIRSTNAME VARCHAR(20),LASTNAME

VARCHAR(20),ADDRESS VARCHAR(20),CITY VARCHAR(20))

mysql>insert into workers values(102,”SAM”,”TONERS”,”33 ELM ST”,”PARIS”);

1. Display names and addresses of all the employees

SELECT FIRSTNAME,LASTNAME,ADDRESS FROM WORKERS;
2. Display the names and city of employees who are from city Paris.
SELECT FIRSTNAME,LASTNAME,CITY FROM WORKERS FROM CITY=”PARIS”;
3. Display details of employees who ever First name begin with letter ‘’S”.
SELECT * FROM WORKERS WHERE FIRSTNAME LIKE “S%”;
4. Remove details of employee 450.
DELETE FROM WORKERS WHERE W_ID = 450;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(SAMPLE F)
Duration:- 3 HOURS Total Marks 30
_____________________________________________________________________________
Q1. To write a Python Program to Create a binary file with roll number and name.
Search for a given roll number and display the name, if not found display appropriate
message. [8]
[ STEPS TO DO BEFORE PYTHON CODE:
OPEN IDLE AND CREATE A NEW FILE AND SAVE THE PYTHON FILE IN DRIVE E: OR D:
]
Q2. Write a program to create a student table and insert data. Write SQL commands for
questions (1) to (3) And Output for (4) and (5) [4]

ROLL_N STD_NAME AGE DEPT DATEOFADM FEE GENDER

O

1 PANKAJ 24 COMPUTER 1997/01/10 120 M

2 SHALINI 21 HISTORY 1998/03/24 200 F

3 SANJAY 22 HINDI 1996/12/12 300 M

4 SUDHA 25 HISTORY 1999/07/01 400 F

5 RAKESH 22 HINDI 1997/09/05 250 M

[ Queries to execute before the select command.

mysql>use practicalD;
mysql>create table student(ROLL_NO INT PRIMARY KEY,STD_NAME VARCHAR(25),AGE
INT,DEPT VARCHAR(20),DATEOFADM DATE,FEE INT,GENDER CHAR(1));
mysql>insert into student values(1,”PANKAJ”,24,”COMPUTER”,”1997/01/10”,120,”M”);
REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY
]
1. Display all the details about students in the History department.
SELECT * FROM STUDENT WHERE DEPT=”HISTORY”;
2. Display the name of female students who are in the Hindi department.
SELECT STD_NAME,DEPT FROM STUDENT WHERE DEPT=”HINDI” AND GENDER=”M”
3. Display average fees department wise.
SELECT DEPT,AVG(FEE) FROM STUDENT GROUP BY DEPT;
4. Remove the details of male students
DELETE FROM STUDENT WHERE GENDER=”MALE”;
Q.3 Report File [8]

Q.4 Project File [7]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(Set G)
Duration:- 3 HOURS Total Marks 30
______________________________________________________________________________
Q1. To write a Python Program to Create a binary file with roll number, name, mark details of
student. and update the marks for a given roll no [8]
[ STEPS TO DO BEFORE PYTHON CODE:
OPEN IDLE AND CREATE A NEW FILE AND SAVE THE PYTHON FILE IN DRIVE E: OR D:
]
Q2. Consider the tables Products and write SQL commands for questions (1) to (4). [4]
TABLE : PRODUCTS
P_ID PRODUCTNAME MANUFACTURER PRICE
RP01 ROSE POWDER LAK 40
BW05 BODY WASH HIM 45
MC01 MOISTURIZING CREAM HIM 75
CO06 CONDITIONER REV 120
BW12 BODY WASH ORI 95
[ QUERIES SHOULD BE EXECUTED BEFORE SELECT COMMAND

mysql>create database practicalG;

mysql>use practicalG;
mysql>create table products(P_ID VARCHAR PRIMARY KEY, PRODUCTNAME VARCHAR(25),
MANUFACTURER VARCHAR(5),PRICE INT));
mysql>insert into products values(“RP01”,”ROSE POWDER”,”LAK”,40);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]

1. Display product Id, product name, manufacturer for Body wash products.
SELECT
P_ID, PRODUCTNAME,MANUFACTURER FROM PRODUCT
WHERE PRODUCTNAME=”BODY WASH”;
2. To increase the price of Conditioner by 20
UPDATE PRODUCTS SET PRICE=PRICE+20 WHERE PRODUCTNAME=”CONDITIONER”;
3. List the average price of products of each manufacturer.
SELECT MANUFACTURER,AVG(PRICE) FROM PRODUCTS GROUP BY MANUFACTURER;
4. Remove details of product which are manufactured by the manufacturer ORI.
DELETE FROM PRODUCT WHERE MANUFACTURER=”ORI”;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(Set H)
Duration:- 3 HOURS Total Marks
30
______________________________________________________________________________
Q1. Write a Python program to calculate the sum of salary and count employees getting
salaries more than 7000 from Myfile.csv. [8]
Aim:
To Write a Python program to calculate the sum of salary and count employees getting salaries
more than 7000 from Myfile.csv.
[ STEPS TO DO BEFORE PYTHON CODE:
create the following csv file Myfile.csv by using notepad
in D: drive or E: drive

1,RAM,6000
2,ARJUN,7500
3,VARUN,2000
4,ANU,4000
5,RAJI,9000

Result:
Thus, the above python program executed successfully and output is verified.
Q2. Consider the tables Clients and write SQL commands for questions (1) to (4). [4]
TABLE : CLIENTS
C_ID CLIENTNAME CITY P_ID
1 COSMETIC SHOP KOLKATA BW05
6 TOTAL HEALTH MUMBAI MC01
12 LIVE LIFE KOLKATA CO06
15 PRETTY WOMAN KOLKATA BW12
16 DREAMS BANGALORE RP01

[
Queries to execute before the select command:

mysql> create database practicalB;

mysql>use practicalB;
mysql>create table clients(C_ID INT PRIMARY KEY,CLIENTNAME VARCHAR(25),CITY
VARCHAR(29), P_ID VARCHAR(10));
mysql>insert into clients values(1,”COSMETIC SHOP”,”KOLKATA”,”BW05”);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]
1. Display client name, city for the client id 15.
SELECT CLIENTNAME, CITY FROM CLIENTS WHERE C_ID=15.
2. Display the client name in ascending order.
SELECT CLIENTNAME FROM CLIENTS ORDER BY CLIENTNAME.
3. Change city of client 12 into DELHI.
UPDATE CLIENTS SET CITY=”DELHI” WHERE C_ID=12;
4. Remove details of client those who are from the city MUMBAI.
DELETE FROM CLIENTS WHERE CITY=”MUMBAI”;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(SAMPLE I)
Duration:- 3 HOURS Total
Marks 30
______________________________________________________________________________
_______
Q1. Write a Python Program to create a text file book.txt with details of the book and read the same
file and display. [8]

[STEPS TO DO BEFORE PYTHON CODE:

open idle , create new python file and save that in drive D: or E:

]
Aim:
To Write a Python Program to create a text file book.txt with details of the book and read the
same file and display.

Result:
 Thus, the above python program executed successfully and the output is verified.
Q2. Consider the table Designation and write SQL commands for questions (1) to (4). [4]

TABLE : DESIGNATION

W_ID SALARY BENEFIT DESIGNATION

102 75000 15000 MANAGER
200 75000 12500 MANAGER
210 35000 10000 CLERK
144 34000 10000 CLERK
450 28000 7500 SALESMAN
105 85000 25000 DIRECTOR
[
QUERIES TO EXECUTE BEFORE THE SELECT COMMAND:

mysql>use practicalC;
mysql>create table designation (W_ID INT PRIMARY KEY,SALARY INT,BENEFIT
INT,DESIGNATION VARCHAR(20));
mysql>insert into designation values(102,75000,15000,”MANAGER”);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]

1. Display w_id and salary of all the Clerks.

SELECT W_ID,SALARY FROM DESIGNATION WHERE DESIGNATION=”CLERK”;
2. Display the maximum salary and designation of employees designation wise
SELECT MAX(SALARY),DESIGNATION FROM DESIGNATION GROUP BY DESIGNATION;
3. Decrease the benefits of Salesman and Managers by 1000.
UPDATE DESIGNATION SET SALARY=SALARY-1000 WHERE DESIGNATION
IN(“MANAGER”,” SALESMAN”);
4. Display salary details of workers who are getting benefits in the range of 10000 to
15000.
Select * from designation where benefit between 10000 and 15000;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]

 AISSCE PRACTICAL EXAMINATION 2023-24
SUBJECT – COMPUTER SCIENCE (083)
CLASS XII
(Set J)
Duration:- 3 HOURS Total Marks 30
______________________________________________________________________________
_______
Q1. Write a program, with separate user-defined functions to perform the following
operations:
(i) To Create a function Push(Stk,D) Where Stack is an empty list and D is Dictionary of Items.
from this Dictionary Push the keys (name of the student) into a stack, where
the corresponding value (marks) is greater than 70.
(ii) To Create a Function Pop(Stk) , where Stk is a Stack implemented by a list of student
names. The function returns the items deleted from the stack.
(iii) To display the elements of the stack (after performing PUSH or POP).
[8]
Q2. Consider the tables Products and write SQL commands for questions (1) to (4). [4]
TABLE : PRODUCTS
P_ID PRODUCTNAME MANUFACTURER PRICE
RP01 ROSE POWDER LAK 40
BW05 BODY WASH HIM 45
MC01 MOISTURIZING CREAM HIM 75
CO06 CONDITIONER REV 120
BW12 BODY WASH ORI 95
[ QUERIES SHOULD BE EXECUTED BEFORE SELECT COMMAND

mysql>create database practicalA;

mysql>use practicalA;
mysql>create table products(P_ID VARCHAR PRIMARY KEY, PRODUCTNAME VARCHAR(25),
MANUFACTURER VARCHAR(5),PRICE INT));
mysql>insert into products values(“RP01”,”ROSE POWDER”,”LAK”,40);

REST OF THE ROWS SHOULD BE INSERTED IN THE SAME WAY

]

1. Display product Id, product name, manufacturer for Body wash products.
SELECT
P_ID, PRODUCTNAME,MANUFACTURER FROM PRODUCT
WHERE PRODUCTNAME=”BODY WASH”;
2. To increase the price of Conditioner by 20
UPDATE PRODUCTS SET PRICE=PRICE+20 WHERE PRODUCTNAME=”CONDITIONER”;
3. List the average price of products of each manufacturer.
SELECT MANUFACTURER,AVG(PRICE) FROM PRODUCTS GROUP BY MANUFACTURER;
4. Remove details of product which are manufactured by the manufacturer ORI.
DELETE FROM PRODUCT WHERE MANUFACTURER=”ORI”;

Q.3 Report File [7]

Q.4 Project File [8]

Q.5 Viva [3]