Page 62 - C++

(i) Display the Trainer Name, City & Salary in descending order of their
Hiredate.

(ii) To display the TNAME and CITY of Trainer who joined the Institute in the
month of December 2001.

(iii) To display TNAME, HIREDATE, CNAME, STARTDATE from tables
TRAINER and COURSE of all those courses whose FEES is less than or
equal to 10000.

(iv) To display number of Trainers from each city.

(v) SELECT TID, TNAME, FROM TRAINER WHERE CITY NOT
IN(‘DELHI’, ‘MUMBAI’);

(vi) SELECT DISTINCT TID FROM COURSE;

(vii) SELECT TID, COUNT(*), MIN(FEES) FROM COURSE GROUP BY
TID HAVING COUNT(*)>1;

(viii) SELECT COUNT(*), SUM(FEES) FROM COURSE WHERE
STARTDATE< ‘2018-09-15’;

6 (a) State any one Distributive Law of Boolean Algebra and Verify it using (2)
truth table.

(b) Draw the Logic Circuit of the following Boolean Expression: (2)
((U + V’).(U + W)). (V + W’)

(c) Derive a Canonical SOP expression for a Boolean function F(X,Y,Z) (1)
represented by the following truth table:

X Y Z F(X,Y,Z)
0 0 0 1
0 0 1 1
0 1 0 0
0 1 1 0
1 0 0 1
1 0 1 0
1 1 0 0
1 1 1 1

(d) Reduce the following Boolean Expression to its simplest form using K- (3)
Map:

F(X,Y,Z,W)= Σ (0,1,2,3,4,5,8,10,11,14)

10