Page 135 - C++
P. 135
iii) SELECT PRICE * QTY AMOUNT FROM PRODUCTS WHERE
PID=104;
Ans: AMOUNT
55000
iv) SELECT PNAME,SNAME FROM PRODUCT P, SUPPLIERS S
WHERE P.SUPCODE=S.SUPCODE AND QTY>100;
Ans: PNAME SNAME
DIGITAL CAMERA PERFECT COMPUTER SYSTEMS
PEN DRIVE 16GB PERFECT COMPUTER SYSTEMS
6. a) Verify the following algebraically. 2
X + Z = X + X’ Z + Y Z
Ans: X+X’Z+YZ = X+Z + YZ ( OTHER LAW)
=X+Z ( ABSORPTION LAW)
b) Write SOP form of a Boolean function H which is represented by the
following truth table. 1
X Y Z H
0 0 0 0
0 0 1 0
0 1 0 1
0 1 1 0
1 0 0 1
1 0 1 0
1 1 0 1
1 1 1 1
Ans: X’YZ’ + XY’Z’ + XYZ’ + XYZ
OR ∑(2,4,6,7)
c) Reduce the Boolean expression using K-map. F(a,b,c,d) = π 3
(0,1,2,3,6,7,8,9,10,13,15)
XII / Comp. Sc. Page 14 of 17
