Answer: a) ID Name E_ID E_NAME 1 Rajesh A1 PKD 1 Rajesh A2 MMK 2 Anil A1 PKD 2 Anil A2 MMK 3 Vishakha A1 PKD 3 Vishakha A2 MMK b) CREATE TABLE STUDENT (Stu_name VARCHAR2(25), F_Name VARCHAR2(25), Age Number(3)); c)Queries: i) SELECT * FROM EMPLOYEE WHERE Department=’SALES’; ii) SELECT * FROM EMPLOYEE WHERE Salary>25000; iii) SELECT * FROM EMPLOYEE WHERE Sex=’M’; iv) SELECT * FROM EMPLOYEE WHERE City=’DELHI’ AND SALARY>26000; v) SELECT * FROM EMPLOYEE WHERE City=’GHAZIABAD' AND Sex=’M’; Q6 a) Law. Explain Demorgan’s b) Develop the Boolean expression for the circuit below. c) Reduce the following Boolean expression using K-Map: F(P,Q,R,S)=Σ(0,3,5,6,7,11,12,15) d) Given the truth table of a function F(x, y, z). Write the s-o-p expression and canonical form from the following truth table:
Answer: a) ID Name E_ID E_NAME 1 Rajesh A1 PKD 1 Rajesh A2 MMK 2 Anil A1 PKD 2 Anil A2 MMK 3 Vishakha A1 PKD 3 Vishakha A2 MMK b) CREATE TABLE STUDENT (Stu_name VARCHAR2(25), F_Name VARCHAR2(25), Age Number(3)); c)Queries: i) SELECT * FROM EMPLOYEE WHERE Department=’SALES’; ii) SELECT * FROM EMPLOYEE WHERE Salary>25000; iii) SELECT * FROM EMPLOYEE WHERE Sex=’M’; iv) SELECT * FROM EMPLOYEE WHERE City=’DELHI’ AND SALARY>26000; v) SELECT * FROM EMPLOYEE WHERE City=’GHAZIABAD' AND Sex=’M’; Q6 a) Explain Demorgan’s Law. b) Develop the Boolean expression for the circuit below. c) Reduce the following Boolean expression using K-Map: F(P,Q,R,S)=Σ(0,3,5,6,7,11,12,15) d) Given the truth table of a function F(x, y, z). Write the s-o-p expression and canonical form from the following truth table: