EMPLOYEE table in the HR data base has the followy

fields:

EMP

$\_$

ID

$,$

$$EMP

$\_$

NAME, DATE

$\_$

$$OF

$\_$

$$BIRTH$,$ DEPARTMENT

$\_$

NAME,

DESIG NATIION, QUALIFICATION

$-$

$$CODE$,$ GRADE, SALARY

SLAB, BASIC

$\_$

$$SALARY$,$ DATE

$\_$

OF

$\_$

$$JOINING$,$ DATE

$\_$

OF

$-$

LAST

$\_$

PROMOTION, JOINING POSITION, NUMIBE

$\_$

OF

$\_$

YEAR

$\_$

$$IN CURRENT

$-$

$$POSITION$,$ DATE

$\_$

$$OF

$\_$

$$LEAVING$,$

DATE

$\_$

OF LAST

$\_$

HIKE, LAST

$\_$

HIKE

$\_$

PERCENT,

AWARDS

$\_$

IN

$\_$

CURRENT

$\_$

YEAR, TOTAL

$\_$

AWARD

$=$

$$YOTD$,$ TRA ININGS ATT ENDED and So on

$.$

the table has around

$3$

$0$

$0$

$0$

$$records of data for

current working employees and about

$8$

$0$

$0$

$0$

$$records

for previous employees who have left the Comping.

As a MIS specialist. Clearly explain how you

Can use this information for decision making

at the tactical level and strategic level

for the HR De partment.