Download CS614 Assignment 2 Solution Fall 2018 In Doc Format

QUESTION NO  1.   

QUESTION NO  2.

1. Create BITMAP index table for columns “Gender” and “Hire_Date”

  1). Columns for “Gender”

EMP ID	MALE	FEMALE
Emp_1	1	0
Emp_2	0	1
Emp_3	1	0
Emp_4	1	0
Emp_5	0	1
Emp_6	1	0
Emp_7	0	1
Emp_8	0	1

2).  Columns for “Hire_Date”

EMP ID	11/17/2000	01/05/2008	01/02/2010	01/01/2003	01/05/2005	01/12/2003
Emp_1	1	0	0	0	0	0
Emp_2	0	1	0	0	0	0
Emp_3	1	0	0	0	0	0
Emp_4	0	0	1	0	0	0
Emp_5	0	0	0	1	0	0
Emp_6	0	0	1	0	0	0
Emp_7	0	0	0	0	1	0
Emp_8	0	0	0	0	0	1

2. Create cluster index for columns “Department” and “Salary”

1). Columns for “Department” .

EMP ID	DEPARTMENT
Emp_1	Administration
Emp_2	Administration
Emp_7	Administration
Emp_3	Production
Emp_6	Production
Emp_4	Marketing
Emp_6	Sales
Emp_7	Sales

2).  Columns for “Salary”

EMP ID	SALARY
Emp_1	50,000

Download Cs614 Assignment Solution File