Page 27 - IP

CBSE AISSCE 2018 Marking Scheme for Informatics Practices
(​Sub Code: 065 Paper Code 90​)

Ans SELECT NAME,PATIENT.TESTID,TESTNAME
/*TEST.TESTID accepted*/
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID
AND DTADMIT BETWEEN ‘01-DEC-2017’ and ’15-DEC-2017’;
OR
SELECT NAME,PATIENT.TESTID,TESTNAME
/*TEST.TESTID accepted*/
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID
AND DTADMIT >=‘01-DEC-2017’and DTADMIT <= ’15-DEC-2017’;
OR
SELECT NAME,P.TESTID,TESTNAME /*T.TESTID accepted*/
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND DTADMIT BETWEEN ‘01-DEC-2017’ and ’15-DEC-2017’;
OR
SELECT NAME,P.TESTID,TESTNAME /*T.TESTID accepted*/
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND DTADMIT >= ‘01-DEC-2017’ and DTADMIT <= ’15-DEC-2017’;
(½ mark for​ ​SELECT​)
(½ mark for ​FROM​)
(½ mark for correct use of join)
(½ mark for correct use of condition)
Note : ​DTADMIT​ ​in default date format (yyyy-mm-dd) should also be accepted
(ii) To display Names of Patients, Test names and Cost of Test for those Patients who have 2
“Sharma” in their names.
Ans SELECT NAME,TESTNAME,COST
FROM PATIENT, TEST
WHERE PATIENT.TESTID = TEST.TESTID
AND Name LIKE ‘%Sharma%’;
OR
SELECT NAME,TESTNAME,COST
FROM PATIENT P, TEST T

WHERE P.TESTID = T.TESTID
AND Name LIKE ‘%Sharma%’;
OR
SELECT P.NAME,T.TESTNAME,T.COST
FROM PATIENT P, TEST T
WHERE P.TESTID = T.TESTID
AND Name LIKE ‘%Sharma%’;
(½ mark for​ ​SELECT​)
(½ mark for ​FROM​)
(½ mark for correct use of join)
(½ mark for correct use of condition)

Page 12 of 13