Page 263 - C++

CBSE AISSCE 2016-2017 Marking Scheme for Computer Science
(Sub Code: 083 Paper Code 91/1 Delhi)

C101 Tarzan in the lost world Comic
F102 Untold Story Fiction
C102 War Heroes Comic
TABLE: MEMBER

MNO MNANE CODE ISSUEDATE
M101 RAGHAV SINHA L102 2016-10-13
M103 SARTHAK JOHN F102 2017-02-23
M102 ANISHA KHAN C101 2016-06-12

(i) To display all details from table MEMBER in descending order of ISSUEDATE.

Ans SELECT * FROM MEMBER ORDER BY ISSUEDATE DESC;

(½ Mark for correct SELECT statement)
(½ Mark for correct ORDER BY clause)

(ii) To display the BNO and BNAME of all Fiction Type books from the table BOOK

Ans SELECT Code,BNAME FROM BOOK WHERE TYPE=’Fiction’;
OR
SELECT BNO,BNAME FROM BOOK WHERE TYPE=’Fiction’;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)
NOTE:
Full 1 Mark for mentioning BNO does not exist in table BOOK

(iii) To display the TYPE and number of books in each TYPE from the table BOOK

Ans SELECT COUNT(*),TYPE FROM BOOK GROUP BY TYPE;

(½ Mark for correct SELECT statement)
(½ Mark for correct GROUP BY clause)

(iv) To display all MNAME and ISSUEDATE of those members from table MEMBER who
have books issued (i.e ISSUEDATE) in the year 2017.

Ans SELECT MNAME, ISSUEDATE FROM MEMBER WHERE
ISSUEDATE>=’2017-01-01’ AND ISSUEDATE<=’2017-12-31’;
OR
SELECT MNAME, ISSUEDATE FROM MEMBER WHERE ISSUEDATE

BETWEEN ‘2017-01-01’ AND ‘2017-12-31’;
OR
SELECT MNAME, ISSUEDATE FROM MEMBER WHERE ISSUEDATE
LIKE ‘2017%’;

(½ Mark for correct SELECT statement)
(½ Mark for correct WHERE clause)

(v) SELECT MAX(ISSUEDATE) FROM MEMBER;

Ans MAX(ISSUEDATE)
2017-02-23

Page #22 of 28