AISSCE PRACTICALS (2023-2024)
SCHOOL CODE:
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: Duration: 3 Hrs Max Marks: 30
1
Create a python program named “Mycsv.py” to store the details of Empno, Name and salary in
“Emp.csv” and search for an Empno entered by the user. If found, display the details of the
Employee else display Empno is not found.
8
2
Write SQL queries for (i) to (iv)
TRAINER
TID
TNAME
CITY
HIREDATE
SALARY
101
SUNAINA
MUMBAI
1998-10-15
90000
102
ANAMIKA
DELHI
1994-12-24
80000
103
DEEPTI
CHANDIGARG
2001-12-21
82000
104
MEENAKSHI
DELHI
2002-12-25
78000
105
RICHA
MUMBAI
1996-01-12
95000
106
MANIPRABHA
CHENNAI
2001-12-12
69000
COURSE
CID
CNAME
FEES
STARTDATE
TID
C201
AGDCA
12000
2018-07-02
101
C202
ADCA
15000
2018-07-15
103
C203
DCA
10000
2018-10-01
102
C204
DDTP
9000
2018-09-15
104
C205
DHN
20000
2018-08-01
101
C206
O LEVEL
18000
2018-07-25
105
4
I. (i) Display the Trainer Name, City & salary in descending order of their Hiredate.
II. (ii) To display the TNAME and CITY of Trainer who joined the Institute in the month of
December 2001.
III. (iii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables TRAINER and COURSE of all
those courses whose FEES is less than or equal to 10000.
IV. (iv)To display number of Trainers from each city.
Internal Examiner External Examiner
Name: …………………………………. Name: ………………………………….
Sign: ……………………………………. Sign: …………………………………….
Examiner No: ……………………………. Examiner No: …………………………
Marks Scored
Max Marks
Python Program
8
SQL Queries
4
Report File
7
Project
8
Viva Voce
3
Total
30
