Page 108 - C++

1167 HARISH B CHEMISTRY 99 27 5

11/05/19
1215 UMESH PHYSICS 98 22 16

ADMIN

CODE GENDER DESIGNATION

1001 MALE VICE PRINCIPAL

1009 FEMALE COORDINATOR

1203 FEMALE COORDINATOR

1045 MALE HOD

1123 MALE SENIOR TEACHER
1167 MALE SENIOR TEACHER

1215 MALE HOD

i) To display TEACHERNAME, PERIODS of all teachers whose periods less than 25.

ii) To display TEACHERNAME, CODE and DESIGNATION from tables SCHOOL and ADMIN
whose gender is male.

iii) To display number of teachers in each subject wise.

iv) To display CODE, TEACHERNAME and SUBJECT of all teachers who have joined the school
after 01/01/1999.

v) SELECT MAX (EXPERIENCE), SUBJECT FROM SCHOOL GROUP BY SUBJECT;

SELECT TEACHERNAME, GENDER FROM SCHOOL, ADMIN WHERE DESIGNATION
=‘COORDINATOR’ AND SCHOOL.CODE=ADMIN.CODE;

vi) SELECT DESIGNATION, COUNT (*) FROM ADMIN GROUP BY DESIGNATION HAVING
COUNT (*) <2;

vii) SELECT COUNT (DISTINCT SUBJECT) FROM SCHOOL;
6.(a) Verify X’.Y+X.Y’=(X’+Y’).(X+Y) algebraically. [2]
(b) Convert the following Boolean expression into its equivalent Canonical Product of Sum form: [1]
A+B.C
(c) Write the equivalent Boolean Expression F for the following circuit diagram : [2]