Section A: Rewrite the following queries:Section B: Answer the following questions based on the query given

SELECT EMP$\_$LNAME, EMP$\_$FNAME, EMP$\_$AREACODE, EMP$\_$GENDER

FROM EMPLOYEE

WHERE $,$ EMP$\_$GENDER AND EMP$\_$AREACODE $={?}^{\text{'}}{615}^{\text{'}}$

ORDER BY EMP$\_$LNAME, EMP$\_$FNAME;

What is the likely data sparsity of the EMP$\_$GENDER column?

What index would you recommend?

SELECT EMP$\_$LNAME, EMP$\_$FNAME, EMP$\_$DOB, YEAR $($EMP$\_$DOB$)$ AS YEAR

FROM EMPLOYEE

WHERE YEAR $($EMP$\_$DOB$)=1966$;

What is the likely data sparsity of the EMP$\_$DOB column?

What index would you recommend?

SELECT $*$ FROM emp WHERE lname $=$ 'FULLER' AND empid $=\text{'}439394\text{'}$;

SELECT $*$ FROM Employee WHERE salary$/12=4000$

SELECT P$\_$NAME FROM PRODUCTS WHERE P$\_$PRICE $-10=7$

SELECT P$\_$NAME FROM PRODUCTS WHERE

$P_{-}$MIN$=P_{-}REORDER{P}_{-}$QOH$=10FL{P}_{-}$QOH AND $P_{-}$MIN$=P_{-}$REORDER AND $P_{-}$QOH$=10$

SELECT $P_N$AME FROM PRODUCTS WHERE $P_P$RICE $>10$ AND $V_S$TATE $=$

$\text{'}FL\text{'}$

$(You$ know that only a few vendors are located $in$ Florida$)$

SELECT $P_N$AME FROM PRODUCTS WHERE NOT $(P_P$RICE $>10\mathrm{.}00)$

SELECT $*$ FROM Employee WHERE NOT $(EM{P}_{S}EX=\text{'}M\text{'})$Assume that $10,000$ vendors are distributed as shown in Table $1.$

Table $1$ Distribution of Vendors by State

Using Table $1$ as an example, create two alternative access plans.

Table $2$ Comparing Access Plans and I$/$O Costs