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 =$=$F$$ AND EMP_$\_$AREACODE =615$=615$

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

1.$1.$ What is the likely data sparsity of the EMP_$\_$GENDER column?

2.$2.$ What index would you recommend?

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

FROM EMPLOYEE

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

3.$3.$ What is the likely data sparsity of the EMP_$\_$DOB column?

4.$4.$ What index would you recommend?

SELECT P_$\_$CODE, P_$\_$PRICE

FROM PRODUCT

WHERE P_$\_$PRICE >=($>=($SELECT AVG($($P_$\_$PRICE)$)$ FROM PRODUCT)$)$;

5.$5.$ What is the likely data sparsity of the P_$\_$PRICE column?

6.$6.$ Should you create an index? Why or why not?

SELECT P_$\_$CODE, SUM($($LINE_$\_$UNITS)$)$

FROM LINE

GROUP BY P_$\_$CODE

HAVING SUM($($LINE_$\_$UNITS)>($)>($SELECT MAX($($LINE_$\_$UNITS)$)$ FROM LINE)$)$;

7.$7.$ What is the likely data sparsity of the LINE_$\_$UNITS column?

8.$8.$ Should you create an index? If so,$,$ what would the index column($($s)$)$ be and why would you create that index?

9.$9.$ Should you create an index on P_$\_$CODE? If so,$,$ write the SQL command to create that index. If not, explain your reasoning.

Answer rating: 100% (QA)

11 The likely data sparsity of the EMPGENDER column is low This is because there are only two possible values for this column M and F Therefore the da... View the full answer