loading...

CS614 Assignment 2 Solution Spring 2018

Question: [05 Marks]
Amdahl’s Law is a statement of the maximum theoretical speed-up you can ever hope to achieve. Amdahl’s law
(given below) assumes that a program consists of a serial part and a parallelizable part. The sequentially
computed fraction of the program is 15% and Speedup is 6.543. For which number of processors do you get this
speedup?
Question: [15 Marks]
Consider the table mentioned below. You have to perform two index operations in context of bitmap index and
cluster indexing.
1. Create index table for columns “Gender” and “Hire_Date”
2. Create cluster index for columns “Department” and “Salary”
Employee_Id Name Gender Designation Departement Phone
Ext.
Salary Hire_Date
Emp_1 Williams
Ron
Male Finance
Manager
Administration 42 50,000 11/17/2000

DOWNLOAD SOLUTION HERE
loading...