Consider the following tables:
DEPT (DCODE, DNAME)
EMP (ECODE, ENAME, BASIC, DCODE, DT_JN)
Write down the SQL statements for the following:
a. SELECT DNAME, SUM(BASIC) “TOTAL” FROM DEPT, EMP WHERE DEPT.DCODE=EMP.DCODE GROUP BY DNAME;
b. SELECT DNAME FROM DEPT WHERE NOT EXISTS (SELECT * FROM EMP WHERE DEPT.DCODE=EMP.DCODE);
c. SELECT ENAME FROM EMP, DEPT WHERE EMP.DCODE=DEPT.DCODE AND DNAME=’ABC’;
d. SELECT MAX(BASIC) “MAX_BASIC” FROM EMP WHERE DT_JN>01JAN2000;
What is the Modularity of a Software System ?
Explain left factoring with suitable example.
Difference between ISO and CMM standards.
Write a C procram to G.C.D. of two no. using recursion.
