# COM 330 Chapter 11 Assignment

Availability: In stock

Regular Price: \$20.00

Special Price: \$15.00

OR

Double click on above image to view full picture

## Quick Overview

COM 330 Chapter 11 Assignment

Find the solutions to Problems 1 and 2 based on the following query:
SELECT    EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX
FROM    EMPLOYEE
WHERE    EMP_SEX = ‘F’ AND EMP_AREACODE = ‘615’
ORDER BY    EMP_LNAME, EMP_FNAME;

1. What is the likely data sparsity of the emp_sex column?
2. What indexes should you create? Write the required sql commands.

Problems 4-6 are based on the following query:
SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEAR(EMP_DOB) AS YEAR
FROM EMPLOYEE
WHERE YEAR(EMP_DOB) = 1966;

4. What is likely data spatsity of the EMP_DOB column?
5. Should you create an index on EMP_DOB?
6. What type of database I/O operations will likely be used by the query?

Regular Price: \$20.00

Special Price: \$15.00

## Details

COM 330 Chapter 11 Assignment

Find the solutions to Problems 1 and 2 based on the following query:
SELECT    EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX
FROM    EMPLOYEE
WHERE    EMP_SEX = ‘F’ AND EMP_AREACODE = ‘615’
ORDER BY    EMP_LNAME, EMP_FNAME;

1. What is the likely data sparsity of the emp_sex column?
2. What indexes should you create? Write the required sql commands.

Problems 4-6 are based on the following query:
SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEAR(EMP_DOB) AS YEAR
FROM EMPLOYEE
WHERE YEAR(EMP_DOB) = 1966;

4. What is likely data spatsity of the EMP_DOB column?
5. Should you create an index on EMP_DOB?
6. What type of database I/O operations will likely be used by the query?

## Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.