Page 264 - C++

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

(½ Mark for correct output)

(vi) SELECT DISTINCT TYPE FROM BOOK;

Ans DISTINCT TYPE
Fiction
Literature
Comic

(½ Mark for correct output)
NOTE: Values may be written in any order

(vii) SELECT A.CODE,BNAME,MNO,MNAME FROM BOOK A, MEMBER B
WHERE A.CODE=B.CODE ;

Ans CODE​ ​BNAME​ ​MNO​ ​MNAME
L102 The priest M101 RAGHAV SINHA
F102 Untold Story M103 SARTHAK JOHN
C101 Tarzan in the lost world M102 ANISHA KHAN

(½ Mark for correct output)

(viii) SELECT BNAME FROM BOOK
WHERE TYPE NOT IN ("FICTION", "COMIC");

Ans BNAME
German Easy

OR
BNAME
The priest
German easy
Tarzan in the lost world
Untold Story
War heroes

(½ Mark for writing any one of the above two outputs)

6 (a) State Distributive Laws of Boolean Algebra and verify them using truth table. 2

Ans (i) X. (Y+Z)= X.Y + X.Z
(ii) X + Y.Z= (X + Y). (X+Z)

Truth Table Verification:
(i)
X Y Z Y + Z X.(Y+Z) X.Y X.Z X.Y + X.Z
0 0 0 0 0 0 0 0
0 0 1 1 0 0 0 0

0 1 0 1 0 0 0 0
0 1 1 1 0 0 0 0
1 0 0 0 0 0 0 0
1 0 1 1 1 0 1 1
1 1 0 1 1 1 0 1

1 1 1 1 1 1 1 1

Page #23 of 28