a. Consider the Employee table given below: ID NAME OCCUPATION 1369 SMITH CLERK 1499 ALLEN SALESMAN 2521 WARD SALESMAN 2566 JONES MANAGER 2654 MARTIN SALESMAN 3698 | BLAKE MANAGER 3788 SCOTT ANALYST 4844 TURNER SALESMAN 5876 ADAMS CLERK 5900 JAMES CLERK 6902 FORD ANALYST 7934 MILLER CLERK Create four bitmap indexes separately for the different values of OCCUPATION Field based on the data given in Table 1. The length of the each bitmap index should be same as the number of rows given in the table. b. An index table is given in Figure 3. Identify the type of indexing used with proper explanation. 101 102 103 105 Stuid Subject 101 DBMS 101 os 101 Math 102 Math 102 OS 103 DBMS 105 os 105 DBMS 105 PHYSICS