KENDRIYA VIDYALAYA DRDO COMPLEX C.V.RAMAN NAGAR BANGALORE 93
MODEL AISSCE PRACTICAL EXAMINATION QUESTIONS 2015-16
SUBJECT : COMPUTER SCIENCE CODE: 083
MAX MARKS:30 TIME: 3 Hours
CBSE ROLL NO:
(a)Write Object Oriented C++ Program to sort the given array of structure in ascending order of average marks using SELECTION Sort.
struct student
{ char name[20];
int avgmak;
};
(b)Consider the following tables GAMES and PLAYER. Write SQL commands for the statements (i) to (iv)
Table: GAMES
GCode / GameName / Number / PrizeMoney / ScheduleDate101 / Carom Board / 2 / 5000 / 23-Jan-2004
102 / Badminton / 2 / 12000 / 12-Dec-2003
103 / Table Tennis / 4 / 8000 / 14-Feb-2004
105 / Chess / 2 / 9000 / 01-Jan-2004
108 / Lawn Tennis / 4 / 25000 / 19-Mar-2004
Table: PLAYER
PCode / Name / Gcode1 / Nabi Ahmad / 101
2 / Ravi Sahai / 108
3 / Jatin / 101
4 / Nazneen / 103
(i) To display the name of all Games with their Gcodes
(ii) To display details of those games which are having PrizeMoney more than 7000.
(iii)To display the content of the GAMES table in ascending order of ScheduleDate.
(iv) To display sum of PrizeMoney for each of the Number of participation groupings (as shown in column Number 2 or 4)
Output for the SQL queries.
(i)SELECT COUNT(DISTINCT Number) FROM GAMES;
(vi) SELECT MAX(ScheduleDate),MIN(ScheduleDate) , COUNT(*) FROM GAMES
GROUP BY Game Name;
(vii) SELECT SUM(PrizeMoney) FROM GAMES;
(viii) SELECT DISTINCT Gcode FROM PLAYER;
(C) F(a,b,c,d)= ∑ (1,3,4,5,7,9,11,12,13,15) obtain the simplified form using K-Map. Draw Logic diagram. 2
(a)Write an Object Oriented C++ Program to implement circular queue of INTEGERS.(Array)
(b)Given the following LAB table, write SQL command for the questions (i) to (iii)
LAB
No / ItemName / CostPerItem / Quantity / Dateofpurchase / Warranty / Operational1 / Computer / 60000 / 9 / 21/5/96 / 2 / 7
2 / Printer / 15000 / 3 / 21/5/97 / 4 / 2
3 / Scanner / 18000 / 1 / 29/8/98 / 3 / 1
4 / Camera / 21000 / 2 / 13/10/96 / 1 / 1
5 / Switch / 8000 / 1 / 31/10/99 / 2 / 1
6 / UPS / 5000 / 5 / 21/5/96 / 1 / 4
7 / Router / 25000 / 2 / 11/1/2000 / 2 / 5
(i)To display the ItemName,whose CostPerItem is more than 20000.
(ii)To display all the itemName whose name starts with “C”.
(iii)To list the ItemName in ascending order of the date of purchase.
(iv)Increase the warranty by 3 for camera.
(v)Give the output of the following SQL commands:
(a)select min(DISTINCT Quantity) from LAB;
(b)select max(Warranty) from LAB;
(c)select sum(CostPerItem) from LAB;
(d)select ItemName from lab where name like ‘C%’;
c) Obtain a simplified form for a Boolean expression2 F(x,y,z,w)=∑(0,1,3,4,5,6,7,9,10,11,13,15) using Karnaugh map. Draw logic diagram.
(a)Write an Object Oriented C++ Program to insert into and delete an element from a dynamically allocated queue (linked list ) where each node contains a floating point number.
(b)Consider the following tables EMPLOYEE and DESIG. write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii)
1
KENDRIYA VIDYALAYA DRDO COMPLEX C.V.RAMAN NAGAR BANGALORE 93
MODEL AISSCE PRACTICAL EXAMINATION QUESTIONS 2015-16
SUBJECT : COMPUTER SCIENCE CODE: 083
MAX MARKS:30 TIME: 3 Hours
CBSE ROLL NO:
EMPLOYEEDESIG
W_ID / FIRSTNAME / LASTNAME / CITY102 / SAM / TONES / PARIS
105 / SARAH / ACKERMAN / NEW YORK
144 / MANILA / SENGUPTA / NEW DELHI
210 / GEORGE / SMITH / HOWARD
255 / MARY / JONES / HUSTON
300 / ROBERT / SAMUEL / WASHINGTON
335 / HENRY / WILLIAMS / BOSTON
400 / RONNY / LEE / NEW YORK
451 / PAT / THOMPSON / PARIS
W_ID / SALARY / BENEFITS / DESIGNATION
102 / 75000 / 15000 / MANAGER
105 / 85000 / 25000 / DIRECTOR
144 / 70000 / 15000 / MANAGER
210 / 75000 / 12500 / MANAGER
255 / 50000 / 12000 / CLERK
300 / 45000 / 10000 / CLERK
335 / 40000 / 10000 / CLERK
400 / 32000 / 7500 / SALESMAN
451 / 28000 / 7500 / SALESMAN
1
KENDRIYA VIDYALAYA DRDO COMPLEX C.V.RAMAN NAGAR BANGALORE 93
MODEL AISSCE PRACTICAL EXAMINATION QUESTIONS 2015-16
SUBJECT : COMPUTER SCIENCE CODE: 083
MAX MARKS:30 TIME: 3 Hours
CBSE ROLL NO:
(i)Display FirstName and City of Employee having salary between 50,000 and 90,000
(ii)Display details of Employees who are from “PARIS” city.
(iii)Increase the benefits of employee having W_ID = 210 by 500.
(iv)Count number of employees whose name starts from character ‘S’.
(v)Select MAX(salary) from desig
(vi)Select FirstName from employee, desig
where designation = ‘MANAGER’ AND employee.W_ID = desig.W_ID;
(vii)Select COUNT (DISTINCT designation) from desig;
(viii)Select designation, SUM(salary) from desig
Group by designation Having count (*) > 2;
(c ) Obtain a simplified form for the following Boolean Expression using K – Map:
F(u,v,w,z) = ∑(0,3,4,5,7,11,13,15)Draw logic diagram.
(a)Write an Object Oriented C++ Program to arrange the array of Employee structure in ascending order of Salary using BUBBLE Sort.
struct EMPL
{ char Name[20];
int EmpId;
float Salary;
};
(b)Study the following tables STAFF and SALARY and write SQL commands for the question (i) to (iv) and give output for SQL queries (v) to (vi)
1
KENDRIYA VIDYALAYA DRDO COMPLEX C.V.RAMAN NAGAR BANGALORE 93
MODEL AISSCE PRACTICAL EXAMINATION QUESTIONS 2015-16
SUBJECT : COMPUTER SCIENCE CODE: 083
MAX MARKS:30 TIME: 3 Hours
CBSE ROLL NO:
relation : STAFF
ID / NAME / DOJ / DEPT / SEX / QUALF101 / Siddharth / 12/01/02 / Sales / M / MBA
104 / Raghav / 8/05/88 / Finance / M / CA
107 / Naman / 14/05/88 / Research / M / MTECH
114 / Nupur / 1/02/03 / Sales / F / MBA
109 / Janvi / 18/7/04 / Finance / F / ICWA
105 / Rama / 14/4/07 / Research / M / BTECH
117 / Jace / 27/6/87 / Sales / F / MTECH
111 / Binoy / 12/1/90 / Finance / M / CA
130 / Samuel / 7/3/99 / Sales / M / MBA
187 / Ragini / 12/12/02 / Research / F / BTECH
relation : SALARY
ID / BASIC / ALLOWANCE / COMM_PERC101 / 15240 / 5400 / 3
104 / 23000 / 1452 / 4
107 / 14870 / 2451 / 3
114 / 21000 / 3451 / 14
109 / 24500 / 1452 / 10
105 / 17000 / 1250 / 2
117 / 12450 / 1400 / 3
111 / 13541 / 3652 / 9
130 / 25000 / 4785 / 15
187 / 14823 / 5862 / 2
1
KENDRIYA VIDYALAYA DRDO COMPLEX C.V.RAMAN NAGAR BANGALORE 93
MODEL AISSCE PRACTICAL EXAMINATION QUESTIONS 2015-16
SUBJECT : COMPUTER SCIENCE CODE: 083
MAX MARKS:30 TIME: 3 Hours
CBSE ROLL NO:
i)Display the name of all CA’s.
ii)Display the number of staff joined year-wise
iii)Hike the Allowance by 2000 for all staff whose ID is less than 105.
iv)Display the average salary given to the employee in each department
v)SELECT DEPT, COUNT(*) FROM STAFF
WHERE SEX=’m’
GROUP BY DEPT
HAVING COUNT(*) >2;
vi) SELECT AVG(BASIC+ ALLOWANCE), QUALF
FROM SALARY S1, STAFF S2
WHERE S1.ID=S2.ID
GROUP BY QUALF;
vii)SELECT DISTINCT QUALF FROM STAFF
viii)SELECT NAME, BASIC+ALLOWANCE
FROM STAFF S, SALARY SA
WHERE S.ID=SA.ID AND YEAR(DOJ)<2002 ;
(c )Reduce the following Boolean expression using K-Map:
F (A, B, C, D) = (0, 1, 2, 3, 4, 5, 10, 11, 15)
(a)Write an Object Oriented C++ Program to insert into and delete an element from a dynamically allocatedstack (linked list ) where each node contains a floating point number.
(b) Consider the following tables SCHOOL and ADMIN. Write SQL commands for the statements (i) to (ix).
SCHOOL
CODE / TEACHERNAME / SUBJECT / DOJ / PERIODS / EXPERIENCE1001 / RAVI SHANKAR / ENGLISH / 12/03/2000 / 24 / 10
1009 / PRIYA RAI / PHYSICS / 03/09/1998 / 26 / 12
1203 / LISA ANAND / ENGLISH / 09/04/2000 / 27 / 5
1045 / YASHRAJ / MATHS / 24/08/2000 / 24 / 15
1123 / GANAN / PHYSICS / 16/07/1999 / 28 / 3
1167 / HARISH B / CHEMISTRY / 19/10/1999 / 27 / 5
1215 / UMESH / PHYSICS / 11/05/1998 / 22 / 16
ADMIN
CODE / GENDER / DESIGNATION1001 / MALE / VICE PRINCIPAL
1009 / FEMALE / COORDINATOR
1203 / FEMALE / COORDINATOR
1045 / MALE / HOD
1123 / MALE / SENIOR TEACHER
1167 / MALE / SENIOR TEACHER
1215 / MALE / HOD
- To display TEACHERNAME, PERIODS of all teachers whose periods less than 25 and name start with R.
- Display the contents of school table in descending order of teacher name.
- Display details of all from table school where experience is between 10 and 20.
- To display TEACHERNAME, CODE and DESIGNATION from tables SCHOOL and ADMIN for female teacher..
- To display the TEACHERNAME who have minimum PERIODS.
- Increase 2 years experience in all the female records.
- Delete all the records of subject physics.
- Insert a row in ADMIN TABLE.
(c)Reduce the following Boolean expression using K-map.3
F(A,B,C,D)= (0,1,2,4,5,6,8,10)
(a)Write Object Oriented C++ Program to sort the given array of structure in ascending order of average marks using INSERTION SORT Sort.
struct student
{ char name[20];
int avgmak; };
(b).Consider the following workers and desig. Write SQL commands for the statements and give outputs for SQL queries
WORKERS
W_ID / FIRSTNAME / LASTNAME / ADDRESS / CITY102 / Sam / Tones / 33 Elm St. / Paris
105 / Sarah / Ackerman / 440 U.S. 110 / New York
144 / Manila / Sengupta / 24 Friends Street / New Delhi
210 / George / Smith / 83 First Street / Howard
255 / Mary / Jones / 842 Vine Ave. / Losantiville
300 / Robert / Samuel / 9 Fifth Cross / Wasington
335 / Henry / Williams / 12Moore Street / Boston
403 / Ronny / Lee / 121 Harrison St. / New York
451 / Pat / Thompson / 11 Red Road / Paris
DESIG
W_ID / SALARY / BENEFITS / DESIGNATION102 / 75000 / 15000 / Manager
105 / 85000 / 25000 / Director
144 / 70000 / 15000 / Manager
210 / 75000 / 12500 / Manager
255 / 50000 / 12000 / Clerk
300 / 45000 / 10000 / Clerk
335 / 40000 / 10000 / Clerk
400 / 32000 / 7500 / Salesman
451 / 28000 / 7500 / Salesman
(i)To display w_id, firstname, address and city of all employees living in new york from the table workers.
(ii)To display the content of workers table in ascending order of lastname.
(iii)To display the firstname, lastname and total salary of all alerks from the tables workers and design, where total salary is calculated as salary + benefits.
(iv)To display the minimum salary among Managers from the table DESIG.
(v)SELECT FIRSTNAME, SALARY FROM WORKERS, DESIG WHERE DESIGNATION = ‘Manager’ AND WORKERS.W_ID = DESIG.W_ID
(vi)SELECT COUNT(DISTINCT DESIGNATION) FROM DESIG.
(vii)SELECT DESIGNATION, SUM(SALARY FROM DESIGNATION GROUP BY DESIGNATION HAVING COUNT(*)<3;
(viii)SELECT SUM(BENEFITS) FROM WORKERS WHERE DESIGNATION = ‘Salesman’;
(C)Reduce the following Boolean expression using K . Map :Draw logic diagram.[2]
F(P, Q, R, S,) =∑ (0,3,5,6,7,11,12,15)
(a)Write an Object Oriented C++ Program to insert into and delete an element from a stack (Array) where each element of array contains a floating point number. 12
(b)Consider the following EMP table. Write SQL commands for the statements and give outputs for SQL queries 5
Table : EMP
EMPNO / ENAME / JOB / MGR / HIREDATE / SAL / COMM / DEPTNO7839 / REA / MANAGER / 67 / 12-DEC-98 / 5000 / 0 / 10
1234 / PREM / CLERK / 87 / 11-FEB-77 / 12000 / 1500 / 20
6754 / SITA / MANAGER / 89 / 12-MAR-99 / 10000 / 1000 / 20
6574 / GITA / SALESMAN / 98 / 11-JUN-99 / 9000 / 0 / 30
9876 / HONEY / CLERK / 65 / 12-JUN-00 / 12000 / 800 / 20
8976 / REEMA / SALESMAN / 91 / 10-SEP-88 / 6000 / 100 / 30
- Display names of employees whose names include either of the substring “TH” or “LL”.
- Display data of all employees sorted by their department and salary.
- Find all the employees who are working under manager 87.
- To display all employees who work in the department of PREM .
- Show the average salary for all departments.
- Find out number of employees having ‘MANAGER’ as job.
- Display department no. and number of employees in each department.
- Find the output of the following :
1. SELECT SYSDATE FROM DUAL;
2. SELECT ENAME,SAL FROM EMPLOYEE WHERE DEPTNO=20;
3. SELECT COUNT(*) FROM EMP;
4. SELECT AVG(SAL) FROM EMP;
(c) Reduce the following Boolean expression using K-map. Draw logic diagram.2
F(P,Q,R,S)= (1,2,3,4,5,6,7,9,11,12,13,15)
(a)Each node of a STACK contains the following information, in addition to required pointer field : (i) Employee number of the employee (ii) Employee Name (iii) Salary. Give the structure,class for the linked stack in question
TOP is pointer to the topmost node of the stack. Write an object oriented C++ program to implement the stack which is allocated dynamically.
(b)Write SQL commands for the statements on the basis of the table
EMPLOYEE:
Name / EmpNo / DeptNo / Job / Sal / CommG. Hussain / 2098 / 10 / President / 7000
Pallav / 3099 / 30 / Manager / 9000 / 1400
Y.D. Sharma / 8001 / 20 / Clerk / 8500
Bhawna / 7901 / 10 / President / 4520 / 300
A. Dasgupta / 5400 / 20 / Analyst / 6580
P. Arora / 3400 / 10 / Clerk / 12000
Col. Singhvi / 2100 / 30 / Manager / 1200 / 500
Amit / 3100 / 30 / Analyst / 3250
A D’souza / 2211 / 10 / Clerk / 6900
- Show sum and average salary for marketing deptt.
- Check all employees have unique names.
- Find al employess whose deptt is same as of ‘Amit’.
- Increase the salary of all employees by 10%,
- Find the deptt that is paying max salaries to its employees.
- Display the details of all the employees having salary less than 10000.
(c)Reduce the following Boolean Expression using K-Map: Draw logic diagram.2
F(A,B,C,D)=(0,1,2,4,5,6,8,10,11,14,15)
(a)Write an Object Oriented C++ program to search for an item present in an array which is in ascending order using Binary search method.
(b)Write SQL commands for the queries given from (i) to (iv) and write the outputs for SQL queries (v) based on relation CLUB given below :
Table : CLUB
Mcode / Mname / Sex / Age / Fees / Type1 / Ashish / M / 25 / 6550 / Monthly
2 / Madhulika / F / 29 / 7124 / Monthly
3 / Niti Singh / F / 31 / 18000 / Yearly
4 / Pratyush / M / 55 / 1200 / Quarterly
5 / Venus Sah / F / 19 / 7600 / Monthly
6 / Anand Seth / M / 45 / 19500 / Life
i) to create above table.
ii) to display Mname, age & fees of those club members whose fees is between 10000 to
15000.
iii) to display Mcode, Mname & Type of all-female members with age in descending order.
iv) to display the total fees of the male and female members separately in a single command.
v) Give the output of the following SQL commands : a) SELECT COUNT(*) FROM CLUB WHERE TYPE=”Monthly” AND FEES>=7124;
b) SELECT AVG(AGE) FROM CLUB WHERE TYPE=”Yearly” OR TYPE=”Quarterly”;
(c) Reduce the following Boolean Expression using K-Map:2
F(A,B,C,D)= π(2,3,4,5,6,7,8,10,11)
(a) Consider the following key set : 42, 29, 74, 11, 65, 58, Write an Object Oriented C++ program to, use Bubble sort to sort the data in Descending order and indicate the sequences of steps required.
(b)Consider the following tables. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii)
Table:PRODUCT
P-ID / PRODUCTNAME / MANUFACTURER / PRICETP01 / Talcom Powder / LAK / 40
FW05 / FaceWash / ABC / 45
BS01 / Bath soap / ABC / 55
SH06 / Shampoo / XYZ / 120
FW12 / FaceWash / XYZ / 95
Table:CLIENT
C_ID / CLIENTNAME / P_ID / CITY01 / Cosmetic Soap / FW05 / Delhi
06 / Total Health / BS01 / Mumbai
12 / Live life / SH06 / Delhi
15 / Pretty Woman / FW12 / Delhi
16 / Dreams / TP01 / Banglore
(i)To display the details of those clients whose city is Delhi.
(ii)To display the details of the Products whose price is in the range of 50 to 100 (Both values included)
(iii)To display the Clientname,city from table client and Productname and price from table product, with their corresponding matching P_ID.
(iv)To increase the price of all products by 10.
(v)SELECT Distinct City from client;
(vi)SELECT Manufacturer ,Max(price),Min(price),count(*) from product group by manufacturer.
(vii)SELECT clientname,manufacturer from product,client where client.p_id=product.p_id;
(viii)SELECT productname,price*4 from product;
(c) Reduce the following Boolean Expression using K-Map:2
F(A,B,C,D)= (2,3,4,5,6,7,8,10,11)
- Define functions stackpush( ) to insert nodes and stackpop( ) to delete nodes, for a linked list implemented stack having the following structure for each node:
struct node
{
char name[20];
int age;
node *LINK;};
Write an object oriented C++ program to implement the stack which is allocated dynamically.
- Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii): on the basis of the table
BOOKS
Book_Id / Book_Name / Author_name / Publishers / Price / Type / QuantityF0001 / The Tears / William Hopkins / First Publ. / 750 / Fiction / 10
F0002 / Thunderbolt / Anna Roberts / First Publ. / 700 / Fiction / 5
T0001 / MyFirstC++ / Brain & Brooke / EPB / 250 / Text / 10
T0002 / C++Brain / A.W. Rossaine / TDH / 325 / Text / 5
C0001 / Fast Cook / Lata Kapoor / EPB / 350 / Cookery / 8
ISSUED
Book_Id / Quantity_IssuedF0001 / 3
T0001 / 1
C0001 / 5
(a)To show Book name, Author name and Price of books of EPB Publishers.
(b)To list the names from books of Fiction type.
(c)To display the names and price of the books in descending order of their price.
(d)To increase the price of all books of First Publ. Publishers by 50.
(e)To display the Book_Id, Book_Name and Quantity_Issued for all books which have been issued. (The query will require contents from both the tables.)
(f)To insert a new row in the table Issued having the following data: ‘F0002’, 4.
(g)Give the output:
(i)SELECT COUNT (DISTINCT Publishers) FROM Books;
(ii)SELECT SUM(Price) FROM Books WHERE Quantity > 5;
(iii)SELECT Book_Name, Author_Name FROM Books WHERE Price <500;
(iv) SELECT COUNT (*) FROM Books;
III.Reduce the following Boolean Expression using K-Map: Draw logic diagram2
F(U,V,W,Z)= ∑(0,1,4,5,6,7,11,12,13,14,15)
(a)Write an Object Oriented C++ program to search for an item present in an array which is in descending order using Binary search method.
(b)Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii): on the basis of the table
(i)To display the names of all senders from Mumbai.
(ii)To display the recID, senderName, senderAddress, RecName,RecAddress for every
recipt.
(ii) To display the sender details in ascending order of SenderName.
(iv)To display number of Recipients from each city.
(v) SELECT DISTINCT SenderCity FROM Sender;
(vi)SELECT A.SenderName A, B.RecName
FROM Sender A, Recipient B WHERE
A.SenderID=B. SenderID AND B.RecCity=.Mumbai.;
(vii)SELECT RecName,RecAddress FROM Recipient
WHERE RecCity Not IN (.Mumbai., Kolkata.);
(viii) SELECT RecID, RecName
FROM Recipient
WHERE SenderID = MU02. OR SenderID = ND50;
(c )Reduce the following Boolean Expression using K-Map: Draw logic diagram2
F(U,V,W,Z)= π(0,1,4,5,6,7,11,12,13,14,15)
(a)Write an Object Oriented C++ program to search for an item present in an array which is in ascending order using Linear search method.
(b)Study the following tables CPU and MONITOR and write SQL commands for the questions (i) to (iv) and give outputs for SQL queries (v) to (vi).
Table : MONITOR
TAB_NO / MAKE / COLOR / MODEL / YEAR / MON_NO1 / Zenith / Black / CRT / 2004 / Z_08
2 / Samsung / White / CRT / 2004 / S_01
3 / Samsung / White / CRT / 2004 / S_02
4 / LG / Black / LCD / 2008 / L_01
5 / LG / Black / LCD / 2008 / L_02
6 / LG / Black / LCD / 2008 / L_03
7 / LG / Black / LCD / 2008 / L_04
Table : CPU
TAB_NO / MODEL / COLOR / YEAR / CPU_NO1 / Zenith / Black / 2003 / Z_12
2 / Zenith / Black / 2003 / Z_08
3 / Wipro / Black / 2005 / W_04
4 / Wipro / Black / 2006 / W_24
5 / Wipro / Black / 2008 / W_25
6 / LG / Gray / 2008 / L_01
7 / LG / Gray / 2008 / L_02
- Display the table number, cpu model, year of all the cpu whose color is black.
- Arrange the contents of table CPU in descending order of YEAR.
- Display the table number, model of CPU, make of monitor that has CPU and monitor color black
- Display number of models in each model of monitor.
- select count(make) from monitor where year between 2003 and 2007;
- select cpu.tab_no, cpu.model, monitor.model from cpu, monitor where cpu.color='Black' AND
monitor.color='Black' AND cpu.tab_no = monitor.tab_no;
(c ) Obtain a simplified form for a Boolean expression2
F (a, b , c, d) = ∏ ( 0, 1, 3, 4, 5, 6, 7, 9, 10, 11, 13, 15) using Karnaugh Map.
(a)Give necessary declarations for a queue containing name and float type number ; also write an Object Oriented C++ Program to insert and delete a node from the queue. You should use linked representation of queue.
(b) Consider the following tables GAMES and PLAYER. Write SQL commands for the statements (i) to (iv) and give outputs for SQL queries (v) to (viii)
Table: GAMES
GCode / GameName / Number / PrizeMoney / ScheduleDate101 / Carom Board / 2 / 5000 / 23-Jan-2004
102 / Badminton / 2 / 12000 / 12-Dec-2003
103 / Table Tennis / 4 / 8000 / 14-Feb-2004
105 / Chess / 2 / 9000 / 01-Jan-2004
108 / Lawn Tennis / 4 / 25000 / 19-Mar-2004
Table: PLAYER