AISSCE PRACTICALS (2023-2024)
SCHOOL CODE: XXXXX
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: 27/09/2023 Duration: 3 Hrs Max Marks: 30
1 Creating a python program named “Mycsv.py” to store the details of Empno, Name and Salary in “Emp.csv” and 8
search for an Empno entered by the user. If found, display the details of the Employee else display Empno is not
present.
2 Write SQL queries for (i) to (iv) 4
(i) To display details of all Trains which Start from New Delhi.
(ii) To display the PNR, PNAME, GENDER and AGE of all Passengers whose AGE is below 50.
(iii) To display total number of MALE and FEMALE Passengers.
(iv) To display details of all Passengers travelling in Trains whose TNO is 12015.
Marks Scored Max Marks
Python Program 8
SQL Queries 4
Report File 7
Project 8
Viva Voce 3
Total 30
Internal Examiner External Examiner
Name:_________________________ Name: _________________________
Sign: _________________________ Sign: _________________________
Examiner No: __________________ Examiner No: __________________
SCHOOL CODE: XXXXX
CODE & SUB: (083) COMPUTER SCIENCE – LAB TEST
Date: 27/09/2023 Duration: 3 Hrs Max Marks: 30
1 Creating a python program named “Mycsv.py” to store the details of Empno, Name and Salary in “Emp.csv” and 8
search for an Empno entered by the user. If found, display the details of the Employee else display Empno is not
present.
2 Write SQL queries for (i) to (iv) 4
(i) To display details of all Trains which Start from New Delhi.
(ii) To display the PNR, PNAME, GENDER and AGE of all Passengers whose AGE is below 50.
(iii) To display total number of MALE and FEMALE Passengers.
(iv) To display details of all Passengers travelling in Trains whose TNO is 12015.
Marks Scored Max Marks
Python Program 8
SQL Queries 4
Report File 7
Project 8
Viva Voce 3
Total 30
Internal Examiner External Examiner
Name:_________________________ Name: _________________________
Sign: _________________________ Sign: _________________________
Examiner No: __________________ Examiner No: __________________
